[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

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 pooled and

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 query on

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 [EMAIL

Re: [ADMIN] connection limit exceeded

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

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

[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

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 the

Re: [ADMIN] connection limit exceeded

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