Re: pg_comparator table diff/sync

> On May 11, 1:16 pm, "Erik 2.0" <e...@q32.com> 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.