On Wed, Nov 23, 2011 at 7:35 PM, Raghavendra < raghavendra....@enterprisedb.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
