Thread: WAL couse die my database?

WAL couse die my database?

From

root

Date:

14 August 2001, 11:06:27

Hellow.
Unfortunaly for me postgresql 7.1.2 builds by default with WAL (and there were'n configure options to turn it of). So
oneof files in $database/xlog was corrupted. Postgres is not starting cose of corrupted WAL files: 
===
DEBUG:  database system was shut down at 2001-08-13 18:38:03 MSD
DEBUG:  ReadRecord: record with zero len at (0, 888385420)
DEBUG:  Invalid primary checkPoint record
DEBUG:  ReadRecord: record with zero len at (0, 888385356)
DEBUG:  Invalid secondary checkPoint record
FATAL 2:  Unable to locate a valid CheckPoint record
===

So how to save my bases and repare WAL files?

Re: WAL couse die my database?

From

Tom Lane

Date:

14 August 2001, 14:02:16

root <shpac@mail.ru> writes:
> Unfortunaly for me postgresql 7.1.2 builds by default with WAL (and
> there were'n configure options to turn it of). So one of files in
> $database/xlog was corrupted.

Do you know what happened to it?  Is there a bug we need to fix here?

> So how to save my bases and repare WAL files?

See contrib/pg_resetxlog.

            regards, tom lane