Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 70160632B70
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Fri, 19 Mar 2010 09:50:52 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 59552-09
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Fri, 19 Mar 2010 12:50:33 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from exprod7og102.obsmtp.com (exprod7og102.obsmtp.com [64.18.2.157])
	by mail.postgresql.org (Postfix) with SMTP id 1A5A7632B5E
	for <pgsql-hackers@postgresql.org>;
	Fri, 19 Mar 2010 09:50:40 -0300 (ADT)
Received: from source ([209.85.219.223]) by exprod7ob102.postini.com
	([64.18.6.12]) with SMTP
	ID DSNKS6NzHpaMrys1xEBoflzc1nUk/NfYedp1@postini.com;
	Fri, 19 Mar 2010 05:50:40 PDT
Received: by ewy23 with SMTP id 23so1633396ewy.24
	for <pgsql-hackers@postgresql.org>;
	Fri, 19 Mar 2010 05:50:37 -0700 (PDT)
Received: by 10.213.95.129 with SMTP id d1mr2419672ebn.13.1269003037437;
	Fri, 19 Mar 2010 05:50:37 -0700 (PDT)
Received: from [192.168.1.117] ([88.195.103.165])
	by mx.google.com with ESMTPS id 14sm364416ewy.14.2010.03.19.05.50.36
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 19 Mar 2010 05:50:36 -0700 (PDT)
Message-ID: <4BA3731A.8080809@enterprisedb.com>
Date: Fri, 19 Mar 2010 14:50:34 +0200
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Organization: EnterpriseDB
User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Simon Riggs <simon@2ndQuadrant.com>, Fujii Masao <masao.fujii@gmail.com>,
	Aidan Van Dyk <aidan@highrise.ca>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously
	retry restoring the next WAL
References: <3f0b79eb1002092105r21e009d3v468496058ba04392@mail.gmail.com>
	<4B73FB99.4080403@enterprisedb.com>
	<1265893599.7341.1454.camel@ebony>
	<4B740613.5090004@enterprisedb.com>
	<20100211140118.GB14128@oak.highrise.ca>
	<4B74118C.30704@enterprisedb.com>
	<20100211144204.GC14128@oak.highrise.ca>
	<4B743E7D.5070603@enterprisedb.com>
	<3f0b79eb1002180337t1fab1395ve3491256672af15f@mail.gmail.com>
	<4BA0B079.3050301@enterprisedb.com>
	<3f0b79eb1003180727g7877743eq81274e014fe70a49@mail.gmail.com>
	<1268988724.3556.3.camel@ebony> <4BA361E4.7020309@enterprisedb.com>
	<29146.1269002614@sss.pgh.pa.us>
In-Reply-To: <29146.1269002614@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.391 tagged_above=-10 required=5 tests=AWL=0.208,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/772
X-Sequence-Number: 159548

Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Simon Riggs wrote:
>>> We might also have written half a file many times. The files in pg_xlog
>>> are suspect whereas the files in the archive are not. If we have both we
>>> should prefer the archive.
> 
>> Yep.
> 
> Really?  That will result in a change in the longstanding behavior of
> ordinary recovery.

Really? Not as far as I can see. Recovery has always tried to restore
WAL files from archive first, falling back to the copy in pg_xlog only
if restore_command returns failure.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com