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 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster