"Charles Duffy" <[EMAIL PROTECTED]> writes: > I have 4 separate Postgres databases (within the same pg cluster) that > I need to replicate across a WAN link. This will be a simple two-node > "master-slave" cluster for the time being. > > I'm planning to move these databases to four separate schema within > the same pg database, so that I don't need to have four Slony clusters > configured. I'm planning on putting each schema in its own replication > set. I'm thinking the 4-cluster scenario would be a bad thing, since > it would complicate administration, and having four Slon daemons each > side of the link might make for more network traffic. > > Has anybody been in a similar situation? Any comments on whether or > not what I've described above is the best way to approach the > situation?
That sounds pretty appropriate. I can't guarantee there will be *no* issues with such a configuration; it warrants some testing, but it otta work, and your plan sounds right. -- select 'cbbrowne' || '@' || 'linuxfinances.info'; http://www3.sympatico.ca/cbbrowne/nonrdbms.html Rules of the Evil Overlord #231. "Mythical guardians will be instructed to ask visitors name, purpose of visit, and whether they have an appointment instead of ancient riddles. <http://www.eviloverlord.com/> _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
