On Fri, Feb 17, 2012 at 2:18 PM, Reinhard Asmus <reinhard.asmus@xxxxxxxxxxxxxx> 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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
