Re: how to use pg_resetxlog - Mailing list pgsql-general

From Tom Lane
Subject Re: how to use pg_resetxlog
Date
Msg-id 3343.1066667836@sss.pgh.pa.us
Whole thread Raw
In response to how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> 1) How do you use  pg_resetxlog?

Read the README file for it.

> 2) Am I at risk of losing all of my data
>    if I use this?

You're at risk of having corrupted data, but I think that's true already
because of the disk failure.

> 3) Some info at groups.google.com suggest that I will
>    have to initdb - I figured that would be good anyway, but
>    how does pg_resetxlog play into this?

After pg_resetxlog you should be able to dump your database.  I'd
recommend doing that, then initdb, reload the dump, look for
inconsistencies ...

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pgsql 7.3.3 on redhat 7.2
Next
From: Tom Lane
Date:
Subject: Re: how to use pg_resetxlog