We intend to establish a central back-up for our system. It can be though as
many machines (masters) linked to one Slave. The communication may be one
directional (master -> slave) and would appreciate to have it almost in realtime.
The data flux on the system is not very high in terms of transactions and
volume of data. And the primary keys are planned in a way that there is no
overlap over the masters (every master has its own range of PK) without
overlapping. We were thinking about slony1.
Since we are not sure about the decision, we would appreciate very much if you
could advise us what to use and where to start.
Thank you very much,
Open WebMail Project (http://openwebmail.org)
pgsql-admin by date
|Next:||From: Sylvain Brohee||Date: 2007-10-18 12:56:03|
|Subject: could not open file "global/pg_database"|
|Previous:||From: yogesh||Date: 2007-10-18 06:01:50|
|Subject: Drop Not Null|