WAL couse die my database?

From: root <shpac(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: WAL couse die my database?
Date: 2001-08-13 15:10:10
Message-ID: 200108131510.TAA17147@fserv.h18
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hellow.
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. 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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2001-08-13 15:23:04 Re: assorted documentation errors
Previous Message pgsql-bugs 2001-08-13 13:32:30 reserved words on table