« Return to Thread: pg_comparator table diff/sync

Re: pg_comparator table diff/sync

by Fabien COELHO-3 :: Rate this Message:

Reply to Author | View in Thread


> On May 11, 1:16 pm, "Erik 2.0" <e...@...> wrote:
>> Is pg_comparator the only project out there that does what it does?  I
>> tried patching it, and it seems OK, but I'm not terribly confident in
>> my patch.  I'm hoping someone will tell me there's a great table-
>> driven rsync out there that everyone uses and I just don't know
>> about.
>
> Slony? But perhaps I'm not understanding what pg_comparator does.

Erik was talking about <http://pgfoundry.org/projects/pg-comparator/>

It just compares table contents (not schema), to point out differing
tuples in two remote locations. Next step is to use the information to
generate the appropriate insert/update/delete statements to resynchronize
the tables, if they are out of sync for some reason and you do not want to
dump/restore the whole stuff.

--
Fabien.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

 « Return to Thread: pg_comparator table diff/sync