[chef] Re: RE: Re: RE: Re: postgres master/slave replication and failover to hot standby

[Tim Uckun < >]

> Repmgr has commands for doing the failover part and adding new nodes as 
> slaves (or setting up a previous master to be a slave etc).
> This should be much nicer than doing it manually. (I haven't used repmgr 
> yet, setting it up is on my extended todo list).


According to their documentation Pgpool does SQL routing sending your
reads to the slaves and writes to the master, it also does sharding.
I guess I'll have to play with both to see which one is more suitable
but it looks like they could be used together too.

Interesting.

>
> -----Original Message-----
> From: Tim Uckun 
> [mailto:
 
> Sent: Tuesday, 24 January 2012 11:05 a.m.
> To: 
> 
 
> Subject: [chef] Re: RE: Re: postgres master/slave replication and failover 
> to hot standby
>
> On Tue, Jan 24, 2012 at 8:38 AM, David Leaver 
> <
 >
>  wrote:
>> You could take a look at repmgr:
>> https://github.com/greg2ndQuadrant/repmgr
>
>
> Does this project take the place of pgpool or are you supposed to use in 
> conjunction with something like that?