psycopg2 OperationalError trouble | Python/Flask/Psycopg2

[BenFifthHour]

hi

I found this thread which may help. my guess was kind of right, the postgres db is closing idle connections older that aroudn 30 minutes.

PostgreSQL "Connection is closed" error after a few minutes of activity

Hello there! I’ve successfully deployed my Python app with a PostgreSQL cluster. The app manages the DB connection using SQLAlchemy with the asyncpg driver. However, I regularly get a server error because the connection between the app and PostgreSQL has been unexpectedly closed. It usually happens after a few minutes (~ 15-30 minutes) of inactivity. Here is the error in details: InterfaceError: connection is closed File "sqlalchemy/dialects/postgresql/asyncpg.py", line 709, in _start_tran…