how to monitor dead connections to postgresql database - Mailing list pgsql-interfaces

From jing han
Subject how to monitor dead connections to postgresql database
Date
Msg-id 20051004132151.11144.qmail@web53513.mail.yahoo.com
Whole thread Raw
List pgsql-interfaces
Hello,

After 6 days busy running, one of my process dead of
cannot connect to database, and the log message shows
that exceeding max_connections. The max_connections =
30.

By running watch -d "ps ax |grep postgres" I only find
6 connections to database, there must be dead
connections laying around and I cannot see them.

Can you tell me how to monitor dead connections to
postgres database?


Thank you!

jing

    
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com


pgsql-interfaces by date:

Previous
From: jing han
Date:
Subject: how to monitor connections to postgres database
Next
From: "Greg Campbell"
Date:
Subject: Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL