Re: In which catalog postgres Instance Crash time recorded ?

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: In which catalog postgres Instance Crash time recorded ?
Date: 2011-11-23 15:11:30
Message-ID: CA+h6Ahh_sZk7x4VzdhvUte8wWyZse23PbUe9fzOCwz4RW34nEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 23, 2011 at 8:35 PM, Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com>wrote:

> On Wed, Nov 23, 2011 at 16:59, Raghavendra
> <raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:
> >
> > Just to clear my question, am looking for this "last known up
> at 2011-11-23
> > 00:45:43 IST" line information recorded in any pg_catalogs ?
>
> How would it read that from a catalog if the cluster didn't recover
> from the crash yet?
>
>
Right.
Am expecting too much. I should have guessed this.. :)

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

---
Raghav

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-11-23 15:31:45 Re: In which catalog postgres Instance Crash time recorded ?
Previous Message Alex Shulgin 2011-11-23 15:05:27 Re: In which catalog postgres Instance Crash time recorded ?