readthefuckingmanual.net

[SOLVED] FATAL: connection limit exceeded for non-superusers

Error added: 2006-01-23T17:10:20Z

5 people waiting for the answer...

3 answers found.

Answer 104 (75.86207% helpful)

There are too many other users connected to the database. Try logging in as a superuser (probably \"su - postgres\", \"psql <target_database>\") and try to find out what\'s going on (SELECT * FROM pg_stat_activity).

Most likely, something\'s running away and keeping connections open. You can close them by saying (as root) `kill -INT <process ID>`, or by restarting Postgres (probably something like /etc/init.d/postgres restart). If it persists, try increasing the maximum number of connections in /var/lib/postgres/data/postgresql.conf.
Permalink

Answer 1415 (40.0% helpful)

Some background process is using a lot of RAM, probably something like an alter table used in a huge table. So, because we don\'t have enough RAM, no more connections are permitted.
Permalink

Answer 1242 (16.666666% helpful)

Am unable to login to db also getting same error.
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: