AssertionError: database connection isn’t set to UTC

AssertionError: database connection isn’t set to UTC

A recent update to psycopg2 version 2.9 is causing this issue

Psycopg 2.9 changed the value passed to tzinfo_factory from an int to a timedelta. Django 2.2 (possibly newer but I’m on 2.2) has a check for offset == 0 and since timedelta(0) != 0 it goes boom.

A current solution would be to downgradepsycopg2 (orpsycopg2-binary if you are using the stand-alone package) below 2.9 (e.g.psycopg2>=2.8,<2.9) in your requirements file.

For instance, you can downgrade to2.8.6 using:

pip install psycopg2==2.8.6

or

pip install psycopg2-binary==2.8.6

If you’re using poetry, you can dopoetry add psycopg2@2.8.6 to fix your version to2.8.6.