| From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
|---|---|
| To: | PG Admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Master to Master replication options? |
| Date: | 2011-08-11 14:39:39 |
| Message-ID: | 4E43E9AB.8060707@consistentstate.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi All;
I have a client that wants the following:
- 2 masters (master to master replication)
- multiple read only slaves off each master
- the ability to failover in case of a master node failure
to include re-directing the slaves off the failed master to now
point to the remaining active master
Questions:
- Is Bucardo the only viable master to master solution?
- Can I setup HOT standby's or SLONY off of a Bucardo master?
- Can I shift a slave's 'master' without a full reset?
Thanks in advance...
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CS DBA | 2011-08-11 14:41:15 | replication from Oracle to PostgreSQL? |
| Previous Message | Igor Neyman | 2011-08-11 14:06:20 | Re: Postgres service starts and then stops immediatly |