In which catalog postgres Instance Crash time recorded ?

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: In which catalog postgres Instance Crash time recorded ?
Date: 2011-11-23 14:05:59
Message-ID: CA+h6AhhXRQx5zfCOn+2ReCnaDbG2RyfwbPBBt72qAe5w2OpvPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
Blog: http://raghavt.blogspot.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Капралов Александр 2011-11-23 14:48:23 Пользователь Капралов Александр хочет пообщаться с вами
Previous Message Achilleas Mantzios 2011-11-23 11:17:20 Re: Optimize the query, help me please.