Обсуждение: how to monitor connections to postgres database

Поиск
Список
Период
Сортировка

how to monitor connections to postgres database

От
jing han
Дата:
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