Search Postgresql Archives

Re: Need to trace the logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Need to trace the logs
From: hubert depesz lubaczewski <depesz@xxxxxxxxxx>
Date: Thu, 15 Oct 2020 15:51:33 +0200
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAHVrmfpx=o0=QzV31D4MaT+-D9S9wWncFGFr7wepszTjNd_+sQ@mail.gmail.com>
References: <CAHVrmfpx=o0=QzV31D4MaT+-D9S9wWncFGFr7wepszTjNd_+sQ@mail.gmail.com>
Reply-to: depesz@xxxxxxxxxx
User-agent: Mutt/1.10.1 (2018-07-13)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Need to trace the logs
  - From: Pavel Stehule

References:
- Need to trace the logs
  - From: nandha kumar

Prev by Date: Need to trace the logs
Next by Date: Re: Need to trace the logs
Previous by thread: Need to trace the logs
Next by thread: Re: Need to trace the logs
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux