Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> writes: > On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
