In which catalog postgres Instance Crash time recorded ?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема In which catalog postgres Instance Crash time recorded ?
Дата
Msg-id CA+h6AhhXRQx5zfCOn+2ReCnaDbG2RyfwbPBBt72qAe5w2OpvPg@mail.gmail.com
обсуждение исходный текст
Ответы Re: In which catalog postgres Instance Crash time recorded ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Список pgsql-general
Дерево обсуждения
Respected All,

Today on my local box, I observed crash and when I started Instance my beginning line of new pg_log's look like this.

2011-11-23 17:18:14 IST [2958]: [1-1]   LOG:  database system was interrupted; last known up at 2011-11-23 00:45:43 IST
2011-11-23 17:18:14 IST [2958]: [2-1]   LOG:  database system was not properly shut down; automatic recovery in progress
2011-11-23 17:18:14 IST [2958]: [3-1]   LOG:  redo starts at 16/C260C028
2011-11-23 17:18:15 IST [2958]: [4-1]   LOG:  record with zero length at 16/C3609308
2011-11-23 17:18:15 IST [2958]: [5-1]   LOG:  redo done at 16/C36092D8
2011-11-23 17:18:15 IST [2958]: [6-1]   LOG:  last completed transaction was at log time 2011-11-23 00:49:21.225383+05:30

Its always there very much information in log's about the crash, and what went wrong etc., 
But my question is, where that crash time is recorded by Postgres, is it in any catalog or in any file ?

Please assist me on this.
Thanks in advance. 

---
Regards,
Raghavendra
EnterpriseDB Corporation

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Optimize the query, help me please.
Следующее
От: Капралов Александр
Дата:
Сообщение: Пользователь Капралов Александр хочет пообщаться с вами