| 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: | Whole Thread | Raw Message | 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 |