Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id A842C64FD1A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 08:12:57 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 33618-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 08:12:54 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.226])
	by mail.postgresql.org (Postfix) with ESMTP id D382E64FC67
	for <pgsql-admin@postgresql.org>; Thu, 20 Nov 2008 08:12:54 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so413758rvf.43
	for <pgsql-admin@postgresql.org>; Thu, 20 Nov 2008 04:12:53 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=Vz6W1JyzI9c0uHt8bzcy5ffxwF7tU2XcyIBU+PJC2/4=;
	b=IJDwEGD4Q/nYCmyMojFBOkLBXv+ZqP+oRGi0ZIB49ZuhEO00zSxYOUfQxHuYhbdpDm
	KhC3X0Rt8VOmV9mQV0GYwQM/dOrCLbr5iiV2ItAk/DLuv8z8NiNKz4WuAiveB4gv15jP
	uS6BGwjWz4FwyqFvMnLN+iBgjbnLncrRk7EcA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=xRekQdiS1UBrt0Vph2HOutc5mNQWJ+gTicv4p8UG0WA98FpL9iBCLmg1QeOKO6ea5P
	tA21Tt9YEgEkTlQWlkV2dvlMqJA58+2IzW22kELrp3kn/t44zcZGjmwU79//Ro24ZvoX
	f1nBe889b7ss//WkT0VDEf5uI7yG16pWYXoJg=
Received: by 10.141.168.2 with SMTP id v2mr1204938rvo.47.1227183173432;
	Thu, 20 Nov 2008 04:12:53 -0800 (PST)
Received: by 10.141.177.18 with HTTP; Thu, 20 Nov 2008 04:12:53 -0800 (PST)
Message-ID: <6c1264780811200412o4875f489v6d2a435f85326447@mail.gmail.com>
Date: Thu, 20 Nov 2008 22:42:53 +1030
From: "Swathi S" <ss.postgres@gmail.com>
To: pgsql-admin@postgresql.org
Subject: User login
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_66425_26522579.1227183173420"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/127
X-Sequence-Number: 30781

------=_Part_66425_26522579.1227183173420
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

How do we find which user logged in from the OS level in postgres.

For eg: If user "a" logged in from the OS level and logged into postgres
psql as user "b" .........how do we find the login details?

------=_Part_66425_26522579.1227183173420
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div>&nbsp;</div>
<div>How do we find which user logged in from the OS level in postgres. </div>
<div>&nbsp;</div>
<div>For eg: If user &quot;a&quot; logged in from the OS level&nbsp;and logged into postgres psql as user &quot;b&quot; .........how do we find the login details?</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>

------=_Part_66425_26522579.1227183173420--