Postgres Pro
Downloads
Home   >   mailing lists

Re: To monitor the number of PostgreSQL database connections? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: To monitor the number of PostgreSQL database connections?
Date
Msg-id 20140326193941.GA475@momjian.us
Whole thread Raw
In response to To monitor the number of PostgreSQL database connections?  (Nithya Soman <nithya@quintetsolutions.com>)
List pgsql-general
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-general by date:

Previous
From: "Hall, Samuel L (Sam)"
Date:
Subject: PgAdmin errors
Next
From: Brian Cosgrove
Date:
Subject: Re: To monitor the number of PostgreSQL database connections?