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

Re: Question about multiple slaves and Master loss.

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: Evan Rempel <erempel(at)uvic(dot)ca>
Cc: Chris Hoover <revoohc(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org Admin"<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Question about multiple slaves and Master loss.
Date: 2011-12-07 18:15:17
Message-ID: EC55DC235432104F8255702A8D7344D925702286@G9W0741.americas.hpqcorp.net (view raw or flat)
Thread:
Lists: pgsql-admin
> -----Original Message-----
> From: Evan Rempel [mailto:erempel(at)uvic(dot)ca]
> Sent: Wednesday, December 07, 2011 1:12 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: Chris Hoover; pgsql-admin(at)postgresql(dot)org Admin
> Subject: Re: [ADMIN] Question about multiple slaves and Master loss.
> 
> Can you have a slave of a slave?
> 
> Basically set up
> 
> A --> B --> C
> also
> A --> D --> E
> 
> if A goes down, promote B which is protected by C
> If B goes down, D is your protection for A
> If C goes down, who cares.
> 
> It takes 5 machines, but would give great protection.
> 

That's called cascaded replication.  It's not currently supported, but coming in 9.2 I believe.

Brad.


In response to

pgsql-admin by date

Next:From: jkellsDate: 2011-12-07 21:22:05
Subject: bad block problem
Previous:From: Evan RempelDate: 2011-12-07 18:11:51
Subject: Re: Question about multiple slaves and Master loss.

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