Re: PITR Backups - Mailing list pgsql-performance

From Gregory Stark
Subject Re: PITR Backups
Date
Msg-id 87ps3kt12r.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: PITR Backups  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: PITR Backups  (Dan Gorman <dgorman@hi5.com>)
List pgsql-performance
"Simon Riggs" <simon@2ndquadrant.com> writes:

>> WARNING: page 28900 of relation 1663/16384/76718 was uninitialized
>> WARNING: page 28902 of relation 1663/16384/76718 was uninitialized
>
>> WARNING: page 26706 of relation 1663/16384/76719 was uninitialized
>> WARNING: page 26708 of relation 1663/16384/76719 was uninitialized
>
> Those two are interesting because we appear to have two valid pages in
> the middle of some uninitialized ones. That implies were not looking at
> an unapplied truncation.

You don't have fsync off do you? That could explain missing pages at the end
of a file like this too. And it would explain how you could have two written
in the midst of others that are missing.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Dan Gorman
Date:
Subject: Re: PITR Backups
Next
From: Tom Lane
Date:
Subject: Re: PITR Backups