Skip site navigation (1) Skip section navigation (2)

Re: Connections to the Database

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(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-17 08:29:35
Message-ID: 4F3E0FEF.10308@orkash.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.
>
>


In response to

pgsql-admin by date

Next:From: Reinhard AsmusDate: 2012-02-17 08:48:04
Subject: Re: Connections to the Database
Previous:From: Reinhard AsmusDate: 2012-02-16 13:21:12
Subject: Connections to the Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group