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: | CA+h6Ahhvd--qYMzVpdBkXuyvX3Pv_og+3pnku41RWjfgqBQqLg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Dicaire | 2012-02-20 15:38:46 | sql query variables not expanded in log file |
Previous Message | Kevin Grittner | 2012-02-17 21:00:51 | Re: Out of memory... |