Upgrade to Python 3.11 and PostgreSQL 15

[codeurimpulsif]

Goal

For a future Debian migration (Bullseye to Bookworm) we need to upgrade εxodus and its dependencies.

Information

Where should we make these changes:

• [ ] Github Workflows
• [ ] Docker : https://github.com/Exodus-Privacy/exodus/pull/599

Dependencies to upgrade:

• [ ] psycopg2 (2.8.6 don't build with Python 3.11, need to use 2.9.1 minimum) : https://github.com/Exodus-Privacy/exodus/pull/599
• [ ] Apkeep don't work with Debian 12, see https://github.com/EFForg/apkeep/issues/178 : https://github.com/Exodus-Privacy/exodus/pull/599

[pnu-s]

@codeurimpulsif So if I understand correctly, we cannot upgrade to Bookworm currently because of this apkeep bug. What do we do then?

[codeurimpulsif]

@pnu-s yes, I try to find a solution (but when you compile it it fail with a No GSF auth token error, I'm still trying to understand differences to find the issue) but for now we can't do anything. I will create a pull request with the Docker changes and Apkeep compilation but leave it as a Draft until we solve this issue.

[codeurimpulsif]

I just write a workaround in https://github.com/Exodus-Privacy/exodus/pull/599.

I build OpenSSL 1.1.1w and then build Apkeep with this OpenSSL version linked.

I think it will work until the Apkeep dev fix the issue with OpenSSL 3.x.