Sat Aug 6 23:39:33 PDT 2005
- Previous message: [Slony1-general] Multiple Slons
- Next message: [Slony1-general] sl_event table not getting cleaned out
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Multiple Slons
- Next message: [Slony1-general] sl_event table not getting cleaned out
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list