Thread: Connections to the Database

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.

Issue the below command :-

select * from pg_stat_activity


& check the results.



Reinhard Asmus wrote:
> 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.
>
>

Zitat von Reinhard Asmus <reinhard.asmus@spdfraktion.de>:

> 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

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