Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 25BAA2E2D73 for ; Thu, 31 Jan 2008 21:56:32 -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 13962-02 for ; Thu, 31 Jan 2008 21:56:16 -0400 (AST) Received: from mx4.ca.afilias.info (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id B74042E013B for ; Thu, 31 Jan 2008 17:37:17 -0400 (AST) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mx4.ca.afilias.info with esmtp (Exim 4.22) id 1JKh5v-0002Ew-FY for pgsql-admin@postgresql.org; Thu, 31 Jan 2008 16:37:15 -0500 Subject: PITR and Failover From: Brad Nicholson To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Thu, 31 Jan 2008 16:37:51 -0500 Message-Id: <1201815471.16171.124.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.12.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/300 X-Sequence-Number: 28074 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? -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.