Re: In which catalog postgres Instance Crash time recorded ?

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