Discovering time of last database write

Поиск
Список
Период
Сортировка
От Andy Dale
Тема Discovering time of last database write
Дата
Msg-id faa313130701040911n788e15eeld3ed52fdfd1967c6@mail.gmail.com
обсуждение исходный текст
Ответы Re: Discovering time of last database write  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
Hi,

I need to be able to determine the last time (and date) that a database was written to.  I know it could be possible just to check the last modified dates in the PGDATA directory, but i need to compare the last write time of 3 databases (connecting via JDBC).  Hopefully the last write date is contained somewhere in a system table (information schema) but i have no idea of the table(s) i would need to query.

Thanks in advance,

Andy

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

Предыдущее
От: Madison Kelly
Дата:
Сообщение: pg_dump question
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Discovering time of last database write