readthefuckingmanual.net

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

Error added: 2013-05-19T13:21:58Z

0 people waiting for the answer...

2 answers found.

Answer 2849 (100.0% helpful)

As postgres user:

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE pid <> pg_backend_pid()
AND state in ('idle');
Permalink

Answer 2130 (75.0% helpful)

/etc/init.d/postgres stop
killall postmaster
killall -9 postmaster
/etc/init.d/postgres start
Permalink

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.


Please enter 61948 here

If you want to be notified via email when this is solved, enter your email address here: