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