From: jing han <jing_han_66@yahoo.com>
To: postgres interface <pgsql-interfaces@postgresql.org>
Subject: how to monitor dead connections to postgresql database
Date: Tue, 4 Oct 2005 06:21:51 -0700 (PDT)
Message-ID: <20051004132151.11144.qmail@web53513.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jing_han_66@yahoo.com
Subject: Re: how to monitor dead connections to postgresql database
In-Reply-To: <20051004132151.11144.qmail@web53513.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox