Re: How to determine date / time of last postmaster restart

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: How to determine date / time of last postmaster restart
Дата
Msg-id 200509072001.01559.peter_e@gmx.net
обсуждение исходный текст
Ответ на How to determine date / time of last postmaster restart  (adey <adey11@gmail.com>)
Список pgsql-admin
adey wrote:
> Please let me know if there is a way to determine when the Postmaster
> was last restarted?

If you have configured your server log to contain timestamps, that is
your best bet to look.  In any case, the server log will tell when the
last shutdown was, so you can at least narrow down the time frame.  You
can also use pg_controldata to check the time of last change to
pg_control (which is changed when the server starts).

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump error... Follow up
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] How to determine date / time of last postmaster restart