|
|
[OX User] OX 0.8.2 database replication
Rudolf Rittmann
rittmann at polytechnic.edu.na
Wed Sep 27 07:45:29 CEST 2006
Hi All,
I'm new to this mailing list, but have been testing OX 0.8.2 for some
time now and are ready to implement this as a production system for our
institution.
We are in the process of installing a second server which we would use a
a replication server for the production one. On this replication server
(slave) we will have the ldap database, imap mailbox database,
postgresql database replicated from the master server.
My big problem is getting slony1.1.1.5 to replicate my open-xchange
database. The database schema for openexchange 0.8.2 has 130 tables from
which only 29 tables have primary keys, unique indexes and sequences.
This is a big problem with slony1, because slony1 replicates only those
tables that falls under these categories as far as I understand. I need
to add primary keys or unique keys to those tables that does not have
them but need help in deciding which columns to choose for as the
primary or unique key.
I would appreciate any help or documentation regarding these issues.
Thank you.
--
Rudolf H. Rittmann
More information about the User
mailing list
|
|