Re: Continuous archiving fails routinely with "invalid magic number" error

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Continuous archiving fails routinely with "invalid magic number" error
Дата
Msg-id 4A1EE37C.EE98.0025.1@wicourts.gov
обсуждение исходный текст
Ответ на Continuous archiving fails routinely with "invalid magic number" error  ("Bruce Reed" <breed@dvdplay.com>)
Ответы Re: Continuous archiving fails routinely with "invalid magic number" error
Список pgsql-admin
"Bruce Reed" <breed@dvdplay.com> wrote:

> May 26 08:58:55 ods2-prod postgres[3827]: [1427-1] LOG:  invalid
> magic number 0000 in log file 194, segment 229, offset 10780672

Try copying to a different name or directory on the target volume and
renaming or moving into place.  It sounds as though maybe the copy is
allocating the file at full size and then copying in the contents, and
the recovery process is sometimes picking it up before it's done.
Either that or the file is being corrupted in transit.

-Kevin

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

Предыдущее
От: "Bruce Reed"
Дата:
Сообщение: Continuous archiving fails routinely with "invalid magic number" error
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Pre-creating partitions incurs insert penalty