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

Keeping two db's in synch across continents

Psychopsam
P: 10
I have one db here and a copy of the db in another country. More often than not we lose the link between the other country.

We need to find a solution to deal with the following.
- To copy data from one field in a db to the other db using a trigger - can this be done with Postgres?
- To determine if the link is down we use our own software, but we need to tell Postgres that it is down when the user pressed enter, and if so we must store the data in a cache until the link is up again - how is this done in Postgres?
- When the link is up it will attempt to write to the db in the other country - can we get Postgres to respond in this way to an external program?

Has anyone done work on this kind of thing before? Is it possible to write a trigger to do that? If this is possible it means we don't have to deal with messy merging.
Jul 20 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
There are many projects aiming to provide solution for database synchronization and replication.
This document may give you an idea on few basic strategies, so you can choose which one fits your situation.

Then you can look at these specific solutions
PostgreSQL Replication Resources
Slony web site
Slony - Concept.pdf
Mammoth Replicator

There could be tools available, personally I am not using any of replicators so I could be out of date with the current development in this area.
Jul 20 '07 #2

Psychopsam
P: 10
Thanks Michael - that's plenty for me to go on with.
Jul 23 '07 #3

Post your reply

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