Andreas Pflug pgadmin
Sat Aug 6 23:39:33 PDT 2005
Rod Taylor wrote:
> 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

No. This is merely an assumption. You can't have too much fantasy how 
weird some apps behave, with users/dbnames/... hardcoded.

Regards,
Andreas


More information about the Slony1-general mailing list