how to monitor connections to postgres database - Mailing list pgsql-interfaces

From jing han
Subject how to monitor connections to postgres database
Date
Msg-id 20051004131110.95231.qmail@web53512.mail.yahoo.com
Whole thread Raw
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Zlatko Matić
Date:
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Next
From: jing han
Date:
Subject: how to monitor dead connections to postgresql database