On Tue, Aug 14, 2007 at 02:13:36PM -0600, Benjamin Krajmalnik wrote:
> I have a client who has 3 branches and a main office.
> All activity is carried out at the branches, but the main office needs
> read only access to a consolidated database.
> Is it possible to set up the three branches as masters, pointing to a
> single slave node (the main office)?
Not without some tricks. If you put each version of the database in
its own schema for each branch, then the main office can be a
replica of each office's schema. If you want a consolidated picture,
you make views. This is all very hand-rolly right now, though.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
