On Mon, Oct 22, 2012 at 2:17 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?
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.