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

[David Leaver < >]

You could take a look at repmgr: https://github.com/greg2ndQuadrant/repmgr

-----Original Message-----
From: Tim Uckun 
[mailto:
 
 
Sent: Monday, 23 January 2012 10:26 p.m.
To: 

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

I too would be interested in this.



On Mon, Jan 23, 2012 at 8:30 PM, Bryan Berry 
<
 >
 wrote:
> I am starting to work on master/slave streaming replication for 
> postgres, based on the database cookbook 
> https://github.com/opscode/cookbooks/tree/master/database
>
> Please note that I am a total n00b to postgres.
>
> I have to figure out to manage failover from master to slave. I 
> imagine that I can do it w/ some kind of script to check whether 
> master is available or not, then promote a slave. However, then I have 
> make sure that a promoted slave is not demoted on the next chef run.
>
> If anyone has experience w/ these issues, I would much appreciate your 
> advice.
>
> If anyone is working on a similar cookbook or has already written 
> something that fulfills my requirements, please let know!
>
> Cheers
>
> BryanWB
>
>
>
>