Hello,
I am using DBReplicator with Postgres 8.2 version. It is working Properly but I want
to Subscribe more then one system, When i make two Subsciber and take Snapshot on
both Subscriber, it is being success. But when i perform Synchronize Operation from both
subscriber changes are reflecting according to whole database of Publisher means if there
is ten rows in subscriber database table and four rows in Publisher database and when i
synch it all data on subscriber side are replacing by data on Publisher side this should not
be happens. According to my requirement data should be updated on indivisual Subscriber
it should not affect other subscriber...
So Can anybody tell me . What should i do for this ?
Regards
AmitC
If I understand you
If I understand you correctly, the you don't want data updated in one subscriber to be updated in the publisher and then the other subscriber(s). To accomplish this (to ONLY take updates from the publisher and move them to the subscribers, and ignore updates at the subscribers), you'll need to use PULL replication. This will PULL updates down from the publisher to subscriber, but not PUSH updates back up from subscriber to publisher.
Hopefully that helps!
B