From: | Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Cc: | Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com> |
Subject: | Log update query along with username who has executed the same. |
Date: | 2017-05-23 12:42:52 |
Message-ID: | c99a53b766334f31b8453d37b460d1e7@cyient.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Dear Expert,
May you please provide the solution for below query.
I have to create a log for all the update query executed in database along with its username who has executed that query.
However, I am able to log all the update queries in my pg_log file but it's not showing particular user who has run the query.
I am using PostgreSQL 9.1 with Linux platform.
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh(dot)chandra(at)cyient(dot)com<mailto:%7Cdinesh(dot)chandra(at)cyient(dot)com>
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Otten | 2017-05-23 12:49:00 | Re: Log update query along with username who has executed the same. |
Previous Message | Gunnar "Nick" Bluth | 2017-05-23 11:03:37 | Re: select subquery versus join subquery |