Re: Utilities for managing streaming replication servers?

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Utilities for managing streaming replication servers?
Date: 2011-03-23 10:35:18
Message-ID: 1B244721-D2D8-43C1-A877-A65C4E9D854A@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 23, 2011, at 11:48 AM, Toby Corkindale wrote:

> I wondered if there were any software packages floating around to manage servers using streaming replication with Pg?
>
> ie. To handle failing over and adjusting the config to promote a slave; and performing the steps of syncing and restarting to bring up a new slave.

You can try repmgr developed by 2nd Quadrant. Link is given below:
http://projects.2ndQuadrant.com/repmgr

You can also try with pgpool failover feature:
http://pgpool.projects.postgresql.org/

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-23 10:51:56 Re: Backups with continuous archiving
Previous Message Adrian Schreyer 2011-03-23 10:08:19 Re: Weird problems with C extension and bytea as input type