Re: To monitor the number of PostgreSQL database connections?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Nithya Soman <nithya(at)quintetsolutions(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: To monitor the number of PostgreSQL database connections?
Date: 2014-03-26 19:39:41
Message-ID: 20140326193941.GA475@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 26, 2014 at 11:01:28AM +0530, Nithya Soman wrote:
> Hi
>
> Could you please provide any method (query or any logfile) to check
> max connections happened during a time interval in psql DB ?

I think there will be a message in the logs when you exceed
max_connections. I think the error string will be:

sorry, too many clients already

That is kind of an odd message.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Cosgrove 2014-03-26 19:42:31 Re: To monitor the number of PostgreSQL database connections?
Previous Message Hall, Samuel L (Sam) 2014-03-26 19:32:33 PgAdmin errors