Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] Log update query along with username who has executed the same. - Mailing list pgsql-performance

From Dinesh Chandra 12108
Subject [PERFORM] Log update query along with username who has executed the same.
Date
Msg-id c99a53b766334f31b8453d37b460d1e7@cyient.com
Whole thread Raw
Responses Re: [PERFORM] Log update query along with username who has executedthe same.  (Rick Otten <rottenwindfish@gmail.com>)
List pgsql-performance
Tree view

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.chandra@cyient.com

Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.

 

pgsql-performance by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: [PERFORM] select subquery versus join subquery
Next
From: Rick Otten
Date:
Subject: Re: [PERFORM] Log update query along with username who has executedthe same.