Re: [ADMIN] Connection Limit Exceeded

2008-12-09 Thread Scott Marlowe
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

[ADMIN] Connection Limit Exceeded

2008-12-09 Thread Steve Kecskes
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

Re: [ADMIN] connection limit exceeded

2007-12-02 Thread Jonah H. Harris
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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Tena Sakai
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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Tena Sakai
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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread 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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Usama Dar
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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Gergely CZUCZY
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

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Jonah H. Harris
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

[ADMIN] connection limit exceeded

2007-11-30 Thread Tena Sakai
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