[ADMIN] Connections to the Database

[Reinhard Asmus]

I install a new database and want to check which connections will be used.

How can i see which application from which host is connecting the database?

Any help is appreciated.

[Adarsh Sharma]

Issue the below command :-

select * from pg_stat_activity


& check the results.

Post by Reinhard Asmus
I install a new database and want to check which connections will be used.
How can i see which application from which host is connecting the database?
Any help is appreciated.

[l***@kwsoft.de]

Post by Reinhard Asmus
I install a new database and want to check which connections will be used.
How can i see which application from which host is connecting the database?
Any help is appreciated.

Hello

if you only want to check from time to time use something like PGAdmin
(http://www.pgadmin.org/). The connections are shown in the statistics
pane for the database in question.

Regards

Andreas

[Reinhard Asmus]

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

[Raghavendra]

On Fri, Feb 17, 2012 at 2:18 PM, Reinhard Asmus <

Post by Reinhard Asmus
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/

Post by Reinhard Asmus
--
http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>