"Charles Duffy" <charles.duffy at gmail.com> 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/>