Re: Question about multiple slaves and Master loss.

> -----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.