Re: [SQL] Connection Limit

2007-07-31 Thread Jon Horsman
Thanks for the help guys, i'll try your suggestions when i get a chance. Jon. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] Connection Limit

2007-07-30 Thread Scott Marlowe
On 7/30/07, Jon Horsman <[EMAIL PROTECTED]> wrote: > Hello, > > I have a server running postgres 7.4.13 and am starting to see errors > "FATAL: connection limit exceeded for non-superusers". > > I'm not sure which one of my applications are hogging all of the > connections, is there a way debug th

Re: [SQL] Connection Limit

2007-07-30 Thread Andrew Sullivan
On Mon, Jul 30, 2007 at 05:41:51PM -0400, Jon Horsman wrote: > > I have a few processes that are running with host = 127.0.0.1 and then > about 90% of all the processes are running as [local]. What does > [local] mean, since in fact 127.0.0.1 is obviously local, how do they > differ? I _believe_

Re: [SQL] Connection Limit

2007-07-30 Thread Jon Horsman
I have another related question when running ps -fax i see the following 7476 ?S 0:00 | \_ postgres: mobileuser mobileextension [local] idle 8046 ?S 0:00 | \_ postgres: mobileuser mobileextension 127.0.0.1 idle I have a few processes that are running wi

[SQL] Connection Limit

2007-07-30 Thread Jon Horsman
Hello, I have a server running postgres 7.4.13 and am starting to see errors "FATAL: connection limit exceeded for non-superusers". I'm not sure which one of my applications are hogging all of the connections, is there a way debug this somehow? Thanks, Jon. ---(end of