Re: Way to quickly detect if database tables/columns/etc. were modified?

Поиск
Список
Период
Сортировка
От Evan Martin
Тема Re: Way to quickly detect if database tables/columns/etc. were modified?
Дата
Msg-id 99d041b3-0e34-00ad-0d6d-6ad2812465f2@realityexists.net
обсуждение исходный текст
Ответ на Re: Way to quickly detect if database tables/columns/etc. were modified?  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: Way to quickly detect if database tables/columns/etc. were modified?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
On 31/10/2016 8:26 PM, Melvin Davidson wrote:
I have tried using an event trigger to detect table creation (ie: tg_event_audit_all ) however, that does not parse the schema_name and objid
as does pg_event_trigger_dropped_objects(), so I am not sure that is a practical way to audit.

Event triggers seem like the most promising suggestion so far (given that I only really need to know that something has changed, not necessarily what).

Still, I was hoping for a solution that doesn't rely on modifying the database at all, i.e. something built into Postgres, but it's pretty clear from everyone's answers nothing like this exists. (I wasn't looking for a creation date, exactly, because I'd want to know when something was modified, too).

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

Предыдущее
От: Patrick B
Дата:
Сообщение: Re: Checking Postgres Streaming replication delay
Следующее
От: Patrick B
Дата:
Сообщение: Turning slave into a master - PostgreSQL 9.2