I was hopeful of restoring the data from data files in $PGDATA path. I read this article about PITR using the
recovery.conf,But I am not aware of the pre-requisites and not entirely sure about the concept beneath this.
Would it not be possible?
Regards,
Akash.
-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Tuesday, October 11, 2011 12:33 AM
To: Scott Marlowe
Cc: Akash Kodibail; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Server crashed
Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>
>> And normal maintenance may be viewing newer data as old, due to
>> transaction wrap-around from the old pg_control file, and
>> removing it as part of normal cleanup. So you may have destroyed
>> some of your more recent data by doing that.
>
> At this point, once you have a backup, would you deploy
> pg_resetxlog?
That's what I was thinking. I shudder to think what autovacuum may
have done while running with the old pg_control file; but I don't
know what else to do at this juncture.
Anyone else have a better idea?
-Kevin
DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for
theaddressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any
disclosure,copying, or distribution of the message, or any action or omission taken by you in reliance on it, is
prohibitedand may be unlawful. Please immediately contact the sender if you have received this message in error.
Further,this e-mail may contain viruses and all reasonable precaution to minimize the risk arising there from is taken
byOnMobile. OnMobile is not liable for any damage sustained by you as a result of any virus in this e-mail. All
applicablevirus checks should be carried out by you before opening this e-mail or any attachment thereto.
Thank you - OnMobile Global Limited.
