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

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

how to monitor dead connections to postgresql database

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