From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Dan Gorman <dgorman@hi5.com>
Cc: Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>
Cc: Toru SHIMOGAKI <shimogaki.toru@oss.ntt.co.jp>
Cc: pgsql-performance@postgresql.org
Subject: Re: PITR Backups
Date: Mon, 25 Jun 2007 13:10:45 -0400
Message-ID: <974.1182791445@sss.pgh.pa.us> (raw)
In-Reply-To: <1182790567.9276.609.camel@silverbirch.site>
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>
"Simon Riggs" <simon@2ndquadrant.com> writes:
>> Reformatting and sorting, we have
>>
>> 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.
Not necessarily --- it's possible the WAL sequence simply didn't touch
those pages.
Your suggestion to rerun the recovery with higher log_min_messages
is a good one, because that way we'd get some detail about what the
WAL records that touched the pages were. I think DEBUG1 would be
sufficient for that, though, and DEBUG2 might be pretty durn verbose.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, simon@2ndquadrant.com, dgorman@hi5.com, suzuki.koichi@oss.ntt.co.jp, shimogaki.toru@oss.ntt.co.jp
Subject: Re: PITR Backups
In-Reply-To: <974.1182791445@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox