Skip site navigation (1) Skip section navigation (2)

connection limit exceeded

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: connection limit exceeded
Date: 2007-11-30 19:55:49
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062DED@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Everybody,

On my postgres 8.1.1, I get a response
  psql: FATAL:  connection limit exceeded for non-superusers

A few questions come to mind...

1) Is this to do with max_connections setting in the postgres
   configuration file?  (my setting is 100 (I think this is the
   default).) 
2) how would I look at the "open/used" connections?
3) should I try restarting postgres without changing the setting?
4) what repercussion would there be if I increase this number to,
   say, 200? (and would that be a good idea?)
5) finally, what's the best fix?  (Do I need to go to pgpool?)

Many thanks in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

pgsql-admin by date

Next:From: Jonah H. HarrisDate: 2007-11-30 20:03:31
Subject: Re: connection limit exceeded
Previous:From: Campbell, LanceDate: 2007-11-30 19:46:53
Subject: Enhancement request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group