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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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