OPEN-XCHANGE
You are here: Community > Mailinglist
freshmeat.net
[OX User] OX 0.8.2 database replication

Rudolf Rittmann rittmann at polytechnic.edu.na
Tue Sep 26 12:09:16 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
http://www.polytechnic.edu.na





More information about the User mailing list