> 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.