Re: Bad pg_xlog with no redo - Mailing list pgsql-general

From Tom Lane
Subject Re: Bad pg_xlog with no redo
Date
Msg-id 27197.1118803131@sss.pgh.pa.us
Whole thread Raw
In response to Bad pg_xlog with no redo  (Pailloncy Jean-Gerard <jg@rilk.com>)
List pgsql-general
Pailloncy Jean-Gerard <jg@rilk.com> writes:
> I have a drive with a bad zone inside the file pgsql/pg_xlog/
> 0000005D000000A1.

> How may I zap the bad pgxlog file ?

pg_resetxlog.  Heed the warnings that your database is not guaranteed
good after you do this.  I'd recommend a dump and reload ... and as much
manual cross-checking as you can manage.

            regards, tom lane

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Next
From: "Qingqing Zhou"
Date:
Subject: Re: (NONE)