Re: In which catalog postgres Instance Crash time recorded ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com>
Cc: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: In which catalog postgres Instance Crash time recorded ?
Date: 2011-11-23 15:31:45
Message-ID: 26320.1322062305@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com> writes:
> How would it read that from a catalog if the cluster didn't recover
> from the crash yet?

> I'd think it's looking at last-modified timestamps of some of the
> PGDATA files instead.

No, it's looking at a last-update timestamp field in pg_control.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2011-11-23 15:51:29 Re: In which catalog postgres Instance Crash time recorded ?
Previous Message Raghavendra 2011-11-23 15:11:30 Re: In which catalog postgres Instance Crash time recorded ?