pg_comparator table diff/sync

[earonesty]

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.

http://pgfoundry.org/tracker/index.php?func=detail&aid=1004603&group_id=1000037&atid=232


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[ahammond]

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.

Andrew


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

[Pavel Stehule]

hello

  I didn't test it, but maybe it is what you are finding

http://pgfoundry.org/projects/apgdiff

regards
Pavel Stehule



14 May 2007 11:11:08 -0700, Andrew Hammond <andrew.george.hammond@...>:

> 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.
>
> Andrew
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Fabien COELHO-3]

> 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

[Michael Raven]

Erik Aronesty wrote:

Is pg_comparator the only project out there that does what it does?

http://www.sqlmanager.net/en/products/postgresql/dbcomparer
http://pgdiff.sourceforge.net/
http://apgdiff.sourceforge.net/