On Mon, Oct 22, 2012 at 7:47 PM, Vishalakshi Navaneethakrishnan <nvishalak...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
