On May 11, 1:16 pm, "Erik 2.0" <[EMAIL PROTECTED]> 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