From: | Chris Hoover <revoohc(at)gmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Question about multiple slaves and Master loss. |
Date: | 2011-12-07 17:04:33 |
Message-ID: | CAD-X90QHZpeE2_ADg1F5Gnb=QmGY4n7Yd_rhF51BM0ZNi9zriQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm pretty sure that the answer to this question is no, but I wanted to
verify.
Given the following scenario (pg 9.0):
Server A (Master), Server B (A's streaming replication Slave), Server C
(A's streaming replication Slave)
If you lose Server A, is there anyway to promote Server B to master and
keep Server C as B's slave without having to rebuild C from a backup of B?
Basically, I'd like to be able to have 2 slaves running so that when the
master goes down, we can bring one slave online, and still have the ability
to very quickly recover if the new master where to fail before server A
could be recovered.
Thanks,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Nicholson, Brad (Toronto, ON, CA) | 2011-12-07 17:58:44 | Re: Question about multiple slaves and Master loss. |
Previous Message | Walter Hurry | 2011-12-07 15:43:22 | Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64 |