On 7/30/07, Jon Horsman <horshaq(at)gmail(dot)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.