Re: Need to trace the logs

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: nandha kumar <bnandhakumardba(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need to trace the logs
Date: 2020-10-15 13:51:33
Message-ID: 20201015135133.GB32444@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2020-10-15 13:55:34 Re: Need to trace the logs
Previous Message nandha kumar 2020-10-15 11:55:11 Need to trace the logs