| From: | jing han <jing_han_66(at)yahoo(dot)com> |
|---|---|
| To: | postgres interface <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | how to monitor dead connections to postgresql database |
| Date: | 2005-10-04 13:21:51 |
| Message-ID: | 20051004132151.11144.qmail@web53513.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Campbell | 2005-10-04 13:34:14 | Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL |
| Previous Message | ozgur.ulku | 2005-10-04 12:43:52 | need help on setting up pgsql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Campbell | 2005-10-04 13:34:14 | Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL |
| Previous Message | jing han | 2005-10-04 13:11:10 | how to monitor connections to postgres database |