On Mon, Oct 22, 2012 at 2:17 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? > > Thanks in advance.. > > Try log_line_prefix parameter, which has many option of writing information into database server logs(pg_logs). You can get IP address of the user who is accessing db, also the application name. Try %r option. http://www.postgresql.org/docs/9.2/static/runtime-config-logging.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
