Re: Bad pg_xlog with no redo

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bad pg_xlog with no redo
Date: 2005-06-15 02:38:51
Message-ID: 27197.1118803131@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pailloncy Jean-Gerard <jg(at)rilk(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-15 03:00:49 Re: Autovacuum in the backend
Previous Message Qingqing Zhou 2005-06-15 02:16:37 Re: (NONE)