On Fri, 2005-08-05 at 21:45 +0000, Andreas Pflug wrote:
> Magnus Hagander wrote:
> >>>People,
> >>>
> >>>It is probably not totally uncommon to have multiple slon backends 
> >>>running on the same machine, replicating different databases. For 
> >>>unix, this is simple - you just start a separate slon daemon. For 
> >>>win32 it's not as simple. I see three options for dealing 
> >>
> >>with this on win32:
> >>
> >>I'd think putting all your data in multiple schemas in one 
> >>database would make for a decent compromise.
> 
> Certainly not. In most cases there was a reason to put the data in 
> different databases, not schemas. Example: Often the same app has to run 
> against several sets of data, but can't deal with schemas.

If you can give the application different databases, you can probably
give it several different users each of which has a different default
schema within the same database (woo for user configurable search
paths).

That said, I see no reason not to implement multi-database replication
if someone was willing to code it.
--