Re: Postgres Login Users Details

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Mon, Oct 22, 2012 at 2:17 PM, Vishalakshi Navaneethakrishnan <nvishalakshi@xxxxxxxxxx> 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/