Re: Table/log file name which store the queries which got executed inlast 1 month

Поиск
Список
Период
Сортировка
От Rene Romero Benavides
Тема Re: Table/log file name which store the queries which got executed inlast 1 month
Дата
Msg-id CANaGW0_XOdEq9+quGtG8HL-4UHnFxvHun=38QR8VLzGDftEPiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Table/log file name which store the queries which got executed inlast 1 month  (Gaurav Tomar <gauravtomar14@gmail.com>)
Ответы Re: Table/log file name which store the queries which got executedin last 1 month  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgsql-sql
Дерево обсуждения
Another option is making use of this trigger in such table https://wiki.postgresql.org/wiki/Audit_trigger , but I would go with logging if the table is very transactional, as suggested by Rob Sargent.  




On Thu, Apr 30, 2020 at 10:20 PM Gaurav Tomar <gauravtomar14@gmail.com> wrote:
Hi All,

In our production environment data in some of the table has been updated from the back end by some user. The update is very random, is there any table which stores the details of queries got executed in last one month or so.

Regards,

Gaurav

+91 876 265 4621



--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Table/log file name which store the queries which got executed inlast 1 month
Следующее
От: legrand legrand
Дата:
Сообщение: Re: Table/log file name which store the queries which got executedin last 1 month