Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 164EA2E021A for ; Fri, 1 Feb 2008 05:56:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 79506-08 for ; Fri, 1 Feb 2008 05:56:16 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 1DFFC2E0268 for ; Fri, 1 Feb 2008 04:59:31 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-21-4.w83-112.abo.wanadoo.fr [83.112.201.4]) by sd-2317.dedibox.fr (Postfix) with ESMTP id 7A2F53446; Fri, 1 Feb 2008 09:59:18 +0100 (CET) Message-ID: <47A2DF62.6030803@lelarge.info> Date: Fri, 01 Feb 2008 09:59:14 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: Brad Nicholson CC: pgsql-admin@postgresql.org Subject: Re: PITR and Failover References: <1201815471.16171.124.camel@bnicholson-desktop> In-Reply-To: <1201815471.16171.124.camel@bnicholson-desktop> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/2 X-Sequence-Number: 28076 Brad Nicholson wrote: > Say I'm using pg_standby to feed wal files from database A into both > database B and database C. > > At some point, I lose A, so I bring Database B up and start the wal > archiving from there. Can I then continue streaming the wal files from > B into C, or do I need to take a new base backup from B and start C from > there? > You need another base backup from B. ISTM that's because server A and server B will be on different timelines when B will finish its restore process. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com