how to monitor connections to postgres database

Поиск
Список
Период
Сортировка
От jing han
Тема how to monitor connections to postgres database
Дата
Msg-id 20051004131110.95231.qmail@web53512.mail.yahoo.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Zlatko Matić
Дата:
Сообщение: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Следующее
От: jing han
Дата:
Сообщение: how to monitor dead connections to postgresql database