Message-ID: <4E43E9AB.8060707@consistentstate.com>
Date: Thu, 11 Aug 2011 08:39:39 -0600
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.18) Gecko/20110621 Fedora/3.1.11-1.fc14 Lightning/1.0b2
	Thunderbird/3.1.11
MIME-Version: 1.0
To: PG Admin <pgsql-admin@postgresql.org>
Subject: Master to Master replication options?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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