Hi,

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?

Thanks,

Charles Duffy