elein elein
Wed Feb 16 18:47:53 PST 2005
For any unique table set there may only be one master.
You may, however, have two disjoint table sets mastered
on different nodes.

--elein

On Wed, Feb 16, 2005 at 08:00:42PM +1300, Glen Eustace wrote:
> I have a database that is mastered on Node 1 and replicated to two
> slaves Nodes 2 and 3. Up until now, all updates to the database have
> been on Node 1 with Nodes 2 and 3 being localised simply to get better
> performance and independence for their Read Only clients.
> 
> I now have a situation where I want a table to be updated on Nodes 2 and
> 3 and have that table replicated amongst all three nodes. I am not sure
> that this is even possible. If it it, how does one set it up ?
> 
> I have created the table in all three databases but it is not yet in the
> replication set. 
> 
> Suggestions, help and advice most welcome.
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Glen and Rosanne Eustace,
> GodZone Internet Services, a division of AGRE Enterprises Ltd.,
> P.O. Box 8020, Palmerston North, New Zealand 5301
> Ph/Fax: +64 6 357 8168, Mob: +64 27 5 424 015, Web: www.godzone.net.nz
> 
> "A Ministry specialising in providing low-cost professional Internet
> Services to NZ Christian Churches, Ministries and Organisations"
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
> 


More information about the Slony1-general mailing list