Re: Error in log file after database crash

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Error in log file after database crash
Дата
Msg-id CAB7nPqTQerHGKA6fjpcac1fsoAjOsFmZb4zS0OkZ8QR9dUxcFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Error in log file after database crash  (Rob Cowell <rob.cowell@transversal.com>)
Список pgsql-general
On Tue, May 10, 2016 at 1:11 AM, Rob Cowell <rob.cowell@transversal.com> wrote:
> Currently I'm running 9.1.10,

9.1.10 has been released in 2013. You are missing 2 years and a half
worth of various fixes, so you may want to update to 9.1.22 first.

> [2016-05-05 20:09:00 UTC]    LOCATION:  XLogFlush, xlog.c:2171
> [2016-05-05 20:09:00 UTC]    WARNING:  58030: could not write block 0 of
pg_tblspc/16395/PG_9.1_201105231/16400/33044487_vm
> [2016-05-05 20:09:00 UTC]    DETAIL:  Multiple failures --- write error might be permanent.
> [2016-05-05 20:09:00 UTC]    LOCATION:  AbortBufferIO, bufmgr.c:2799

This looks like corrupted data, but that's hard to tell with this
level of details. Rolling in a logical backup may be the best way to
go forward here.
--
Michael


В списке pgsql-general по дате отправления:

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Using both ident and password in pg_hba.conf
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: Inserting into a master table with partitions does not return rows affected.