Question about multiple slaves and Master loss.

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Question about multiple slaves and Master loss.
Дата
Msg-id CAD-X90QHZpeE2_ADg1F5Gnb=QmGY4n7Yd_rhF51BM0ZNi9zriQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about multiple slaves and Master loss.  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Walter Hurry
Дата:
Сообщение: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Следующее
От: "Nicholson, Brad (Toronto, ON, CA)"
Дата:
Сообщение: Re: Question about multiple slaves and Master loss.