Hi,
Just wondering what actually happens when the connection limit exceeds.
Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit
exceeded for non-superusers
Are the requests that are rejected pooled and processed when connection
slots are available?
--
Sent via pgsql-admin
On Tue, Dec 9, 2008 at 4:10 PM, Steve Kecskes [EMAIL PROTECTED] wrote:
Hi,
Just wondering what actually happens when the connection limit exceeds.
Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit
exceeded for non-superusers
Are the requests that are rejected pooled and
On Nov 30, 2007 3:34 PM, Tena Sakai [EMAIL PROTECTED] wrote:
This is a wonderful view! How would I properly terminate
these (of course there are 99 of them!) these query process?
Should I do this from unix or is there any postgres tool I
can use?
pg_cancel_backend will cancel a query on
Many thanks, Usama!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Usama Dar [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 1:24 PM
To: Tena Sakai
Cc: Jonah H. Harris; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Dec 1, 2007 1:34 AM, Tena Sakai
Many thanks, Jonah!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 1:17 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Nov 30, 2007 3:34 PM, Tena Sakai [EMAIL
Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Nov 30, 2007 2:55 PM, Tena Sakai [EMAIL PROTECTED] wrote:
On my postgres 8.1.1, I get a response
psql: FATAL: connection limit exceeded for non-superusers
1) Is this to do with max_connections
Hi,
I also have this issue (I'm using 8.2.4), but whenever this happens
I see only a few (4-6) postgresql processes in the system, and my
connection limit is set to 128. Kinda strange. Next time when I
notice it I will check pg_stat_activity and report back.
On Fri, Nov 30, 2007 at 03:03:31PM
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
On Nov 30, 2007 2:55 PM, Tena Sakai [EMAIL PROTECTED] wrote:
On my postgres 8.1.1, I get a response
psql: FATAL: connection limit exceeded for non-superusers
1) Is this to do with max_connections setting in the postgres
configuration file? (my setting is 100 (I think this is the
?
Thank you.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 12:03 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Nov 30, 2007 2:55 PM, Tena Sakai [EMAIL
10 matches
Mail list logo