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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group