On Wed, Nov 23, 2011 at 10:27 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Raghavendra <raghavendra....@enterprisedb.com> writes: > > On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <t...@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 > Perfect. I understood. Thanks for explaining Tom... :) --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
