Related

Product Now Available: Managed PostgreSQL Databases Product
Is possible to connect a DO K8s cluster with a DO Droplet private network? Question Question
How did my database got hacked ? Question Question

Question

My PostgreSQL close unexpectedly the connection

Posted March 10, 2019 8.8k views
Server OptimizationPostgreSQLUbuntu 18.04

Hello I’ve a PostgreSQL server which is presenting a problem that always says the server close the connection unexpectedly, how can I fix this? I am using flask
This is the error:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

Add a comment
hidura
By:
hidura
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
3 answers
jarland March 22, 2019

Greetings!

To learn more about what is happening here, it may be important for you to review the logs for Postgres. You can read more information about logging and error reporting on Postgres here:

https://www.postgresql.org/docs/9.1/runtime-config-logging.html

Jarland

Reply Report
sabuhishukurov December 8, 2019

We have same problem as well in digital ocean, we are unable to solve this issue. did you find any solution for that?

Reply Report
vashchukmaksim December 19, 2019

I have absolutely the same error with psycopg2 and can not find any solution. I submitted a ticket to the support. I can successfully connect with any GUI client or psql and make a query but it fails from within the application.

If anybody solved this?

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help