I wonder what would be a good way to merge data from two databases with same desing and schemas.
We have two Postgres databases in two different countries. I would like to synch these databases on a daily basis. All the tables in our databases have primary keys defined and contain row version numbers, which would help us identify how to merge rows with the same primary key values. What would be an optimal or a typical way to do this? Can I access a remote database running Postgres 7.2.1?
thanks.
Oleg