Re: In which catalog postgres Instance Crash time recorded ?

On Wed, Nov 23, 2011 at 7:35 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> 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/
>
>
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*

*
*
Just to clear my question, am looking for this "last known up at 2011-11-23
00:45:43 IST" line information recorded in any pg_catalogs ?

--Raghav