Need to trace the logs

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Need to trace the logs

nandha kumar
Hi Team,
     We are using a postgresql database with 9.6.1 version, any way to trace the last modified object, procedure in PostgreSQL.


Regards,
Nandhakumar B


Reply | Threaded
Open this post in threaded view
|

Re: Need to trace the logs

hubert depesz lubaczewski-2
On Thu, Oct 15, 2020 at 05:25:11PM +0530, nandha kumar wrote:
> Hi Team,
>      We are using a postgresql database with 9.6.1 version, any way to
> trace the last modified object, procedure in PostgreSQL.

well, you can log all queries, and extract the info from logs.

If by "object" you mean table/row - you can do it with triggers.

Best regards,

depesz



Reply | Threaded
Open this post in threaded view
|

Re: Need to trace the logs

Pavel Stehule


čt 15. 10. 2020 v 15:51 odesílatel hubert depesz lubaczewski <[hidden email]> napsal:
On Thu, Oct 15, 2020 at 05:25:11PM +0530, nandha kumar wrote:
> Hi Team,
>      We are using a postgresql database with 9.6.1 version, any way to
> trace the last modified object, procedure in PostgreSQL.

well, you can log all queries, and extract the info from logs.

If by "object" you mean table/row - you can do it with triggers.

Event triggers are designed for this purpose


Regards

Pavel


Best regards,

depesz