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

[Bryan Berry < >]

As a total n00b i haven't thought out all these parts yet. You are correct that neither repmgr nor pgbouncer handle routing of reads and writes. I will have to investigate pgpool for the distribution part.

On Tue, Jan 24, 2012 at 1:08 AM, Tim Uckun < "> > wrote:

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