Re: Could not locate a valid checkpoint record

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Could not locate a valid checkpoint record
Дата
Msg-id 13078.1277390884@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Could not locate a valid checkpoint record  (Norberto Delle <betodelle@gmail.com>)
Ответы Re: Could not locate a valid checkpoint record  (Norberto Delle <betodelle@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE