Re: Connection Limit - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Connection Limit
Date
Msg-id dcc563d10707301520i1f561703q88427e5408b83933@mail.gmail.com
Whole thread Raw
In response to Connection Limit  ("Jon Horsman" <horshaq@gmail.com>)
Responses Re: Connection Limit  ("Jon Horsman" <horshaq@gmail.com>)
List pgsql-sql
On 7/30/07, Jon Horsman <horshaq@gmail.com> 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 this somehow?

try netstat -an|grep 5432

assuming you're running pgsql on port 5432.  The nice thing about this
trick is that since postgresql uses /tmp/.s.PGSQL.5432 for local
connections, you'll see those too.


pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Table-name as parameter to plpgsql
Next
From: "Milen A. Radev"
Date:
Subject: Re: Table-name as parameter to plpgsql