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 p
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 ma
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 quer
postgres tool I
can use?
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
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 <[EM
inal Message-
> From: Jonah H. Harris [mailto:[EMAIL PROTECTED]<[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 <[EMAI
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 -05
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 t
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 wo
10 matches
Mail list logo