| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: PITR and Failover |
| Date: | 2008-02-01 08:59:14 |
| Message-ID: | 47A2DF62.6030803@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bronson, Allan B. (Mission Systems) | 2008-02-01 15:08:23 | SSL question |
| Previous Message | Tom Lane | 2008-02-01 05:55:49 | Re: Legacy foreign keys |