Postgres Pro
Downloads
Home   >   mailing lists

Re: Continuous archiving fails routinely with "invalid magic number" error - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Continuous archiving fails routinely with "invalid magic number" error
Date
Msg-id 4A1EE37C.EE98.0025.1@wicourts.gov
Whole thread Raw
In response to Continuous archiving fails routinely with "invalid magic number" error  ("Bruce Reed" <breed@dvdplay.com>)
Responses Re: Continuous archiving fails routinely with "invalid magic number" error
List pgsql-admin
Tree view 
"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 by date:

Previous
From: "Bruce Reed"
Date:
Subject: Continuous archiving fails routinely with "invalid magic number" error
Next
From: Scott Marlowe
Date:
Subject: Re: Pre-creating partitions incurs insert penalty