CODEWITHSUNDEEP
postgresql
kissmeimpolish
kissmeimpolish

Reputation: 37

PostgreSQL 10 error: server closed the connection unexpectedly

When I run a query that takes a long time on my Postgres server (maybe 30 minutes), I get the error. I've verified the query is running with active status on the server using pgAdmin. I've also verified the correctness of the query, as it runs successfully on a smaller dataset. Server configurations are default, I haven't changed anything. Please help!

Upvotes: 1

Views: 5747

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246013

Look into the PostgreSQL server log.

Either you'll find a crash report there, which would explain the broken connection, or there is something in your network that cuts connections with no activity after a while.

Investigate your firewalls!

Maybe it is a solution to set the configuration parameter tcp_keepalives_idle to a value shorter than the time when the connection is cut. That will cause the server operating system to send keepalive messages on idle connections, which may be enough to prevent the overzealous connection reaper in your environment from disrupting your work.

Upvotes: 2

Related Questions