Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 65CD42AB7EA
	for <pgsql-admin@postgresql.org>; Fri, 17 Feb 2012 04:27:25 -0400 (AST)
Received: from smtp122.dfw.emailsrvr.com ([67.192.241.122])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adarsh.sharma@orkash.com>) id 1RyJA4-0002jq-K1
	for pgsql-admin@postgresql.org; Fri, 17 Feb 2012 08:27:24 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp2.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id
	A2927781F6; Fri, 17 Feb 2012 03:27:11 -0500 (EST)
X-Virus-Scanned: OK
Received: by smtp2.relay.dfw1a.emailsrvr.com (Authenticated sender:
	adarsh.sharma-AT-orkash.com) with ESMTPSA id A42F9781CB;
	Fri, 17 Feb 2012 03:27:10 -0500 (EST)
Message-ID: <4F3E0FEF.10308@orkash.com>
Date: Fri, 17 Feb 2012 13:59:35 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: Reinhard Asmus <reinhard.asmus@spdfraktion.de>
CC: pgsql-admin@postgresql.org
Subject: Re: Connections to the Database
References: <4F3D02C8.7080903@spdfraktion.de>
In-Reply-To: <4F3D02C8.7080903@spdfraktion.de>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.7 (/)
X-Archive-Number: 201202/72
X-Sequence-Number: 39132

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.
>
>