From: jing han <jing_han_66@yahoo.com>
To: postgres interface <pgsql-interfaces@postgresql.org>
Subject: how to monitor connections to postgres database
Date: Tue, 4 Oct 2005 06:11:10 -0700 (PDT)
Message-ID: <20051004131110.95231.qmail@web53512.mail.yahoo.com> (raw)
Hello,
I met a problem that the max_connections configured in
postgresql.conf are exceeded when my program runs for
6 days. I set max_connections = 30.
I use watch -d "ps ax |grep postgres" to monitor how
many connections to database, I found my program have
at most 6 connections to database. I couldn't figure
out how the max_connections are exceeded.
Is this the only way to monitor how many connections
to database? Are there other ways to monitor how many
connections to database?
Any help will be highly appreciated.
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 connections to postgres database
In-Reply-To: <20051004131110.95231.qmail@web53512.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