Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2E8309FB5B8
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 13:03:11 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 50345-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 13:03:00 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from oxford.xeocode.com (unknown [62.232.55.118])
	by postgresql.org (Postfix) with ESMTP id 9D5C29FB7E1
	for <pgsql-performance@postgresql.org>;
	Mon, 25 Jun 2007 13:03:00 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.67)
	(envelope-from <stark@enterprisedb.com>)
	id 1I2r1h-0001Ov-W5; Mon, 25 Jun 2007 17:02:54 +0100
From: Gregory Stark <stark@enterprisedb.com>
To: "Dan Gorman" <dgorman@hi5.com>
Cc: "Simon Riggs" <simon@2ndquadrant.com>,
	"Koichi Suzuki" <suzuki.koichi@oss.ntt.co.jp>,
	"Toru SHIMOGAKI" <shimogaki.toru@oss.ntt.co.jp>,
	"Tom Lane" <tgl@sss.pgh.pa.us>, <pgsql-performance@postgresql.org>
Subject: Re: PITR Backups
In-Reply-To: <D9E96F55-3AF6-4DC7-A68A-251567976E88@hi5.com> (Dan Gorman's
	message of "Mon, 25 Jun 2007 08:28:51 -0700")
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>
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 1312)
Date: Mon, 25 Jun 2007 17:02:53 +0100
Message-ID: <87bqf4uimq.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
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/574
X-Sequence-Number: 25607

"Dan Gorman" <dgorman@hi5.com> writes:

> I took several snapshots. In all cases the FS was fine. In one case the db
> looked like on recovery it thought there were outstanding  pages to be written
> to disk as seen below and the db wouldn't start.
>
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [9-1] 2007-06-21 00:39:43
> PDTLOG:  redo done at 71/99870670
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [10-1] 2007-06-21 00:39:43
> PDTWARNING:  page 28905 of relation 1663/16384/76718 was  uninitialized

What version of Postgres did you say this was?

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