Re: In which catalog postgres Instance Crash time recorded ? - Mailing list pgsql-general

From Tom Lane
Subject Re: In which catalog postgres Instance Crash time recorded ?
Date
Msg-id 27936.1322067444@sss.pgh.pa.us
Whole thread Raw
In response to Re: In which catalog postgres Instance Crash time recorded ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: In which catalog postgres Instance Crash time recorded ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Raghavendra <raghavendra.rao@enterprisedb.com> writes:
> On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> No, it's looking at a last-update timestamp field in pg_control.

> So, Is it a approximate time of crash on the basis of last-modified
> timestamp of pg_control file ?

IIRC, that's going to be the time of last checkpoint completion on a
normally-operating server.  So depending on your checkpoint settings,
and how busy the server is, it might or might not be very close to
the time of crash.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump of a v8.3.4 -> v9.0.1
Next
From: Raghavendra
Date:
Subject: Re: In which catalog postgres Instance Crash time recorded ?