Re: In which catalog postgres Instance Crash time recorded ?

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

On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>

Thanks Tom.

So, Is it a approximate time of crash on the basis of last-modified
timestamp of pg_control file ?

--Raghav

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2011-11-23 16:08:59 pg_dump of a v8.3.4 -> v9.0.1
Previous Message Tom Lane 2011-11-23 15:31:45 Re: In which catalog postgres Instance Crash time recorded ?