View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 09:42 AM
Fabien COELHO
 
Posts: n/a
Default 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.

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

Reply With Quote