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

Re: Connections to the Database

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: Reinhard Asmus <reinhard(dot)asmus(at)spdfraktion(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Connections to the Database
Date: 2012-02-20 07:33:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Fri, Feb 17, 2012 at 2:18 PM, Reinhard Asmus <
reinhard(dot)asmus(at)spdfraktion(dot)de> wrote:

> select * from pg_stat_activity show me informations to working connections
> but i will see informations (application and ip-address) to failed
> connections
> in this situation i can see problems in my pg_log but not the information
> to application and ip-address
pg_stat_activity is standard statistic view which is dynamically updated.

Very true, failed connection's information can be pull from
pg_logs. However, you need to tune your logging setting to write
information about connections. See log_connections & log_disconnections

EnterpriseDB Corporation

> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-admin by date

Next:From: Rick DicaireDate: 2012-02-20 15:38:46
Subject: sql query variables not expanded in log file
Previous:From: Kevin GrittnerDate: 2012-02-17 21:00:51
Subject: Re: Out of memory...

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