Skip site navigation (1) Skip section navigation (2)

how to monitor dead connections to postgresql database

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

Responses

pgsql-interfaces by date

Next:From: Greg CampbellDate: 2005-10-04 13:34:14
Subject: Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Previous:From: jing hanDate: 2005-10-04 13:11:10
Subject: how to monitor connections to postgres database

pgsql-general by date

Next:From: Greg CampbellDate: 2005-10-04 13:34:14
Subject: Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Previous:From: ozgur.ulkuDate: 2005-10-04 12:43:52
Subject: need help on setting up pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group