search

akvo / akvo-reporting

Akvo reporting integration
2 stars 1 forks source link

Connection to Postgres borked #8

Open zzgvh opened 9 years ago

zzgvh commented 9 years ago

This morning when trying to connect to the database nothing worked. When I tried connecting using my PG viewer, using the tunnel, I saw the error:

psql: FATAL: remaining connection slots are reserved for non-replication superuser connections

Somehow PG ran out of connections. I couldn't run reports on the server and not connect from Eclipse. I could however connect using psql on the server itself so it's connections that fail not the DB itself. Restarting postgres cleared the issue, but this is something we need to be on the lookout for and try to investigate if it turns up again.

iperdomo commented 9 years ago

Check the max_connections configuration.

http://www.postgresql.org/docs/current/static/runtime-config-connection.html

And if we're leaking and leaving stalled open connections?