Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with
the new replication features? I poked around for awhile but didn’t find
anything. I’d rather not reinvent the wheel if someone’s already got a good
head start.
Thanks,
-Kevin
Kevin,
I don't have a cookbook I can share but I have been working on getting Postgres 9.1 working in my environment and found the following really helpful:
http://wiki.postgresql.org/wiki/Streaming_Replication
Beyond what is in that doc you just need to set synchronous_standby_names to the application_name in the recovery.conf if you want synchronous replication.
I think that's about it. It's not the same as a recipe but I hope this helps.
-Joe
--
Name: Joseph A. Williams
Email: joe@joetify.com
Blog: http://www.joeandmotorboat.com/
Twitter: http://twitter.com/williamsjoe
On Friday, September 16, 2011 at 12:30 PM, Kevin Nuckolls wrote:
Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with the new replication features? I poked around for awhile but didn't find anything. I'd rather not reinvent the wheel if someone's already got a good head start.
Thanks,
-Kevin
I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait for
repmgr 2.0 to come out).
Installation, including SSH key distribution (to allow the postgres accounts
to rsync between themselves) and cluster initialization is fully automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.
On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls kevin.nuckolls@gmail.comwrote:
Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a good
head start.Thanks,
-Kevin
stop teasing us, let us get our grubby hands on it 
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:
I've got one for 9.0 I've been using in production for some time, but it needs some work to take advantage of 9.1 (work which will probably wait for repmgr 2.0 to come out).
Installation, including SSH key distribution (to allow the postgres accounts to rsync between themselves) and cluster initialization is fully automatic. Failover requires some manual involvement at this time. I'll post to the list once it's released.
On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls kevin.nuckolls@gmail.com wrote:
Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with the new replication features? I poked around for awhile but didn't find anything. I'd rather not reinvent the wheel if someone's already got a good head start.Thanks,
-Kevin
Don't forget there's a Chef Cookbook Contest going on:
Thanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.
matt@opscode.com | (512) 731-2218
Twitter, IRC, GitHub: mattray
On Mon, Sep 19, 2011 at 6:45 PM, Alex Soto apsoto@gmail.com wrote:
stop teasing us, let us get our grubby hands on it
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait for
repmgr 2.0 to come out).Installation, including SSH key distribution (to allow the postgres accounts
to rsync between themselves) and cluster initialization is fully automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls kevin.nuckolls@gmail.com
wrote:Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a good
head start.
Thanks,
-Kevin
Just following up. Any forward motion on open sourcing those cookbooks?
Thanks,
-Kevin
On Tue, Sep 20, 2011 at 9:34 AM, Matt Ray matt@opscode.com wrote:
Don't forget there's a Chef Cookbook Contest going on:
http://www.opscode.com/blog/2011/08/22/cookbook-contest/Thanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.
matt@opscode.com | (512) 731-2218
Twitter, IRC, GitHub: mattrayOn Mon, Sep 19, 2011 at 6:45 PM, Alex Soto apsoto@gmail.com wrote:
stop teasing us, let us get our grubby hands on it
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait
for
repmgr 2.0 to come out).Installation, including SSH key distribution (to allow the postgres
accounts
to rsync between themselves) and cluster initialization is fully
automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls <
kevin.nuckolls@gmail.com>
wrote:Has anyone already released a solid cookbook for Postgres 9.0 or 9.1
with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a
good
head start.
Thanks,
-Kevin
Not mine -- in fact, it's actually gained more proprietary dependencies
since this was last discussed.
On Mon, Oct 3, 2011 at 3:49 PM, Kevin Nuckolls kevin.nuckolls@gmail.comwrote:
Just following up. Any forward motion on open sourcing those cookbooks?
Thanks,
-KevinOn Tue, Sep 20, 2011 at 9:34 AM, Matt Ray matt@opscode.com wrote:
Don't forget there's a Chef Cookbook Contest going on:
http://www.opscode.com/blog/2011/08/22/cookbook-contest/Thanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.
matt@opscode.com | (512) 731-2218
Twitter, IRC, GitHub: mattrayOn Mon, Sep 19, 2011 at 6:45 PM, Alex Soto apsoto@gmail.com wrote:
stop teasing us, let us get our grubby hands on it
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait
for
repmgr 2.0 to come out).Installation, including SSH key distribution (to allow the postgres
accounts
to rsync between themselves) and cluster initialization is fully
automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls <
kevin.nuckolls@gmail.com>
wrote:Has anyone already released a solid cookbook for Postgres 9.0 or 9.1
with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a
good
head start.
Thanks,
-Kevin
Kevin,
Looked at http://community.opscode.com/cookbooks/postgresql91 ?
Thanks
On Oct 3, 2011, at 1:49 PM, Kevin Nuckolls wrote:
Just following up. Any forward motion on open sourcing those cookbooks?
Thanks,
-KevinOn Tue, Sep 20, 2011 at 9:34 AM, Matt Ray matt@opscode.com wrote:
Don't forget there's a Chef Cookbook Contest going on:
http://www.opscode.com/blog/2011/08/22/cookbook-contest/Thanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.
matt@opscode.com | (512) 731-2218
Twitter, IRC, GitHub: mattrayOn Mon, Sep 19, 2011 at 6:45 PM, Alex Soto apsoto@gmail.com wrote:
stop teasing us, let us get our grubby hands on it
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait for
repmgr 2.0 to come out).Installation, including SSH key distribution (to allow the postgres accounts
to rsync between themselves) and cluster initialization is fully automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls kevin.nuckolls@gmail.com
wrote:Has anyone already released a solid cookbook for Postgres 9.0 or 9.1 with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a good
head start.
Thanks,
-Kevin!DSPAM:4e8a1fd5223552060713880!
I haven't but thanks for bubbling this up. I'll check it out. 
-Kevin
On Tue, May 22, 2012 at 9:55 AM, Scott M. Likens scott@likens.us wrote:
Kevin,
Looked at http://community.opscode.com/cookbooks/postgresql91 ?
Thanks
On Oct 3, 2011, at 1:49 PM, Kevin Nuckolls wrote:
Just following up. Any forward motion on open sourcing those cookbooks?
Thanks,
-KevinOn Tue, Sep 20, 2011 at 9:34 AM, Matt Ray matt@opscode.com wrote:
Don't forget there's a Chef Cookbook Contest going on:
Opscode's First Chef Cookbook Contest! - Chef Blog | ChefThanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.
matt@opscode.com | (512) 731-2218
Twitter, IRC, GitHub: mattrayOn Mon, Sep 19, 2011 at 6:45 PM, Alex Soto apsoto@gmail.com wrote:
stop teasing us, let us get our grubby hands on it
On Sep 19, 2011, at 4:14 PM, Charles Duffy wrote:I've got one for 9.0 I've been using in production for some time, but it
needs some work to take advantage of 9.1 (work which will probably wait
for
repmgr 2.0 to come out).Installation, including SSH key distribution (to allow the postgres
accounts
to rsync between themselves) and cluster initialization is fully
automatic.
Failover requires some manual involvement at this time. I'll post to the
list once it's released.On Fri, Sep 16, 2011 at 2:30 PM, Kevin Nuckolls <
kevin.nuckolls@gmail.com>
wrote:Has anyone already released a solid cookbook for Postgres 9.0 or 9.1
with
the new replication features? I poked around for awhile but didn't find
anything. I'd rather not reinvent the wheel if someone's already got a
good
head start.
Thanks,
-Kevin!DSPAM:4e8a1fd5223552060713880!