On 09/27/10 8:08 PM, novnovice wrote:
Can anyone recommend a relatively simple merge replication package that would
work well on windows and which relies on one of the current postgresql
versions? 9 would be fine for my needs. I'm a fairly unsophisticated
postgresql user; and not very experienced with replication on other
databases. So the simplest to configure and maintain solution would be best.
I am not sure but it sounds like the new replication features that come
baked in to postgres 9 are not so oriented towards merge replication - is
that right?
My use case would involve a primary postgresql database and several
postgresql databases on disconnected notebook computers. All dbs need to be
able to support updates inserts etc; and then hopefully the replication
software would help with things like conflict resolution.
One of the fundamental tenets of Relational Database is that there is
One Version of the Truth.
I don't think there's a transparent generic solution to offline
replicant re-syncing that isn't full of thorny issues in all sorts of
corner cases.
I would instead design your app so it writes a logfile of database
changes at an abstract application level, and has a method for replaying
this log when the scout hooks back up with the mothership. Common
practice is for this sync process to toss any conflicts into an
exception log and notify the admins to deal with it. If you design it
right, the administrator can add new processing rules and resubmit the
exception log until its empty :)
if there's any question about the veracity of the notebooks copy after
synching its application change log, I'd consider loading it with a
fresh copy of the master, unless this is really expensive because of Db
size.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
