Postgres Pro
Downloads
Home   >   mailing lists

Question about multiple slaves and Master loss. - Mailing list pgsql-admin

From Chris Hoover
Subject Question about multiple slaves and Master loss.
Date
Msg-id CAD-X90QHZpeE2_ADg1F5Gnb=QmGY4n7Yd_rhF51BM0ZNi9zriQ@mail.gmail.com
Whole thread Raw
Responses Re: Question about multiple slaves and Master loss.  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Walter Hurry
Date:
Subject: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Next
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: Question about multiple slaves and Master loss.