Wed Feb 16 18:47:53 PST 2005
- Previous message: [Slony1-general] Slave to Master ?
- Next message: [Slony1-general] Does Slony-I skip unnecessary updates?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 >
- Previous message: [Slony1-general] Slave to Master ?
- Next message: [Slony1-general] Does Slony-I skip unnecessary updates?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list