Re: files under pg_clog directories are missing

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: dbhandary(at)iii(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: files under pg_clog directories are missing
Date: 2010-09-20 16:37:47
Message-ID: 201009201637.o8KGblT29400@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dinesh Bhandary wrote:
> Good reminder to backup before you start. Yes, I've made the backup of
> the db in its current state.
>
> After reading your posts and doing a slew of research I am inclining
> more towards restoring from the last successful dump and reload data
> from applications (it seems like it is going to be partial recovery). I
> am concerned that even if we are able to clear all those messages by
> whatever means the state of the database will be corrupted. Luckily this

True.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Smith 2010-09-20 18:15:39 Re: files under pg_clog directories are missing
Previous Message Dinesh Bhandary 2010-09-20 16:03:02 Re: files under pg_clog directories are missing