From: Gregory Stark <stark@enterprisedb.com>
To: "Simon Riggs" <simon@2ndquadrant.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Dan Gorman" <dgorman@hi5.com>,
	"Koichi Suzuki" <suzuki.koichi@oss.ntt.co.jp>,
	"Toru SHIMOGAKI" <shimogaki.toru@oss.ntt.co.jp>,
	<pgsql-performance@postgresql.org>
Subject: Re: PITR Backups
In-Reply-To: <1182790567.9276.609.camel@silverbirch.site> (Simon Riggs's
	message of "Mon, 25 Jun 2007 17:56:06 +0100")
Organization: EnterpriseDB
References: <7E0807EE-B970-4869-A248-B838E42AD9EE@hi5.com>
	<9761.1182472005@sss.pgh.pa.us> <467B3459.9030808@oss.ntt.co.jp>
	<1182509748.9276.178.camel@silverbirch.site>
	<467F938F.1030708@oss.ntt.co.jp>
	<1182777963.9276.582.camel@silverbirch.site>
	<D9E96F55-3AF6-4DC7-A68A-251567976E88@hi5.com>
	<367.1182789258@sss.pgh.pa.us>
	<1182790567.9276.609.camel@silverbirch.site>
Date: Mon, 25 Jun 2007 18:07:24 +0100
Message-ID: <87ps3kt12r.fsf@oxford.xeocode.com>
User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

"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