Re: PITR Backups

[Dan Gorman <dgorman@xxxxxxx>]

No, however, I will attach the postgreql.conf so everyone can look at  
other settings just in case.

Attachment: postgresql.conf
Description: Binary data

Regards,
Dan Gorman

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

> "Simon Riggs" <simon@xxxxxxxxxxxxxxx> 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