Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> writes:
> On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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