Incompatible versions of psycopg2 and Django

[astrojuanlu]

I think, that this might have broken something. I am trying to get the development setup running and after following the instructions from the Development Installation section, I get an

AssertionError at /accounts/login/
database connection isn't set to UTC

when trying to login as admin:admin at community.dev.readthedocs.io/accounts/login. After a little bit of googling, I found

• this StackOverflow question
• this psycopg issue
• and this django issue

Currently, you seem to have django pinned to 2.2.24 and psycopg2/psycopg2-binary to 2.9.1 which is not a supported combination according to the above issues.

---

Edit: I tried manually reverting the psycopg2 pins and after rebuilding the docker images, the issue was seemingly fixed

diff --git a/requirements/deploy.txt b/requirements/deploy.txt
index e3809df00..72cc39e89 100644
--- a/requirements/deploy.txt
+++ b/requirements/deploy.txt
@@ -1,7 +1,7 @@
 # Requirements for our production systems
 
 -r pip.txt
-psycopg2==2.9.1
+psycopg2==2.8.6
 gunicorn==20.1.0
 
 # Version 3.0.0 drops support for Django < 3.0
diff --git a/requirements/docker.txt b/requirements/docker.txt
index 15c8d56fd..a90325484 100644
--- a/requirements/docker.txt
+++ b/requirements/docker.txt
@@ -2,7 +2,7 @@
 
 -r pip.txt
 # https://www.psycopg.org/docs/install.html#psycopg-vs-psycopg-binary
-psycopg2-binary==2.9.1
+psycopg2-binary==2.8.6
 
 # Version 3.0.0 drops support for Django < 3.0
 # https://github.com/sebleier/django-redis-cache/#300

Originally posted by @ruro in #8293 (comment)

[astrojuanlu]

I confirm I can reproduce this one as well.