Skip site navigation (1) Skip section navigation (2)

PITR and Failover

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: PITR and Failover
Date: 2008-01-31 21:37:51
Message-ID: 1201815471.16171.124.camel@bnicholson-desktop (view raw or flat)
Thread:
Lists: pgsql-admin
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.



Responses

pgsql-admin by date

Next:From: Peter KoczanDate: 2008-02-01 00:13:23
Subject: Re: Legacy foreign keys
Previous:From: Simon RiggsDate: 2008-01-31 15:58:32
Subject: Re: [GENERAL] Backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group