Re: Need to trace the logs

Поиск

Список

Период

Сортировка

От	Pavel Stehule
Тема	Re: Need to trace the logs
Дата	15 октября 2020 г. 16:55:34
Msg-id	CAFj8pRCNKLnu-KFGKS5QQW+gxoGF_WetRVUV0OD9vHeRTuq4oA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Need to trace the logs (hubert depesz lubaczewski <depesz@depesz.com>)
Список	pgsql-general

Дерево обсуждения

čt 15. 10. 2020 v 15:51 odesílatel hubert depesz lubaczewski <depesz@depesz.com> 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

https://www.postgresql.org/docs/9.6/event-triggers.html

Regards

Pavel