Re: PITR Backups - Mailing list pgsql-performance

From Dan Gorman
Subject Re: PITR Backups
Date
Msg-id 0CE91499-DE2B-4092-948C-9265428DE5C3@hi5.com
Whole thread Raw
In response to Re: PITR Backups  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
No, however, I will attach the postgreql.conf so everyone can look at
other settings just in case.

Regards,
Dan Gorman

On Jun 25, 2007, at 10:07 AM, Gregory Stark wrote:

> "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
>


Attachment

pgsql-performance by date:

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