By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,083 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,083 IT Pros & Developers. It's quick & easy.

Slony-I questions

Psychopsam
P: 10
So on the quest of trying to synch two or more db's I've had problems try to get two PSQL Replicator db's to connect.

My requirements are as follows
  • Two way comms - master / slave model wont work
  • The "other" db is on another continent where the connection drops out all the time.
  • Merging is not an issue - it must lock tables and / or columns

So I started looking at Slony-I which is built into PSQL. but I stumbled across this info (below) pretty early on and I was wondering if people have found a work around for this or can suggest other replication techniques / software to deal with this - for what I require above.
If you have nodes that are likely to regularly drop onto and off of the network, or have nodes that cannot be kept secure, Slony-I is probably not the ideal replication solution for you.
It is also true that Slony-I is Master/Slave -
Slony-I is a "master to multiple slaves" replication system supporting cascading and slave promotion.
Aug 10 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.