On Mon, Oct 22, 2012 at 7:47 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi@sirahu.com> wrote:
> Hi all,
>
> I need to know who are all access database from different remote host.
>
> Example :
>
> User1@host1 logged / access db dbuser@dbname in Dbserver
>
> How can i get this information?
As suggested, you can configure logging to record this. For
up-to-the-moment "who's currently logged in" information, look at the
pg_stat_activity table.
ChrisA