Postgres 9 Cookbook


#1

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


#2

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


#3

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


#4

stop teasing us, let us get our grubby hands on it :slight_smile:

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


#5

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 :slight_smile:
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


#6

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: 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 :slight_smile:
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


#7

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,
-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: 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 :slight_smile:
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


#8

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,
-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: 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 :slight_smile:
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!


#9

I haven’t but thanks for bubbling this up. I’ll check it out. :smiley:

-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,
-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: 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 :slight_smile:
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!