Re: Could not locate a valid checkpoint record - Mailing list pgsql-general

From Tom Lane
Subject Re: Could not locate a valid checkpoint record
Date
Msg-id 13078.1277390884@sss.pgh.pa.us
Whole thread Raw
In response to Could not locate a valid checkpoint record  (Norberto Delle <betodelle@gmail.com>)
Responses Re: Could not locate a valid checkpoint record  (Norberto Delle <betodelle@gmail.com>)
List pgsql-general
Norberto Delle <betodelle@gmail.com> writes:
> 2010-06-24 09:00:28 PANIC:  could not locate a valid checkpoint record

> I know this error requires you to restore from backup, but,
> unfortunatelly, we have no backup.
> There is any way I can recover the data?

pg_resetxlog should allow you to restart the database, but it's anyone's
guess as to whether the data will be corrupt.  A dump and reload would
be a good idea.  You also need to investigate what happened to your
pg_xlog files and take steps to make sure it doesn't happen again.
(Since this is evidently Windows, I would suggest being sure you're
using a recent/supported PG release, and take a close look at what AV
software you're using.)

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE