Re: Connections to the Database
| От | Raghavendra |
|---|---|
| Тема | Re: Connections to the Database |
| Дата | |
| Msg-id | CA+h6Ahhvd--qYMzVpdBkXuyvX3Pv_og+3pnku41RWjfgqBQqLg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Connections to the Database (Reinhard Asmus <reinhard.asmus@spdfraktion.de>) |
| Список | pgsql-admin |
On Fri, Feb 17, 2012 at 2:18 PM, Reinhard Asmus <reinhard.asmus@spdfraktion.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
В списке pgsql-admin по дате отправления: