pg_comparator table diff/sync
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
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.
Andrew
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@gmail.com>:
Show quoted text
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.
Andrew
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
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.
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://www.sqlmanager.net/en/products/postgresql/dbcomparer
http://pgdiff.sourceforge.net/ http://pgdiff.sourceforge.net/
http://apgdiff.sourceforge.net/ http://apgdiff.sourceforge.net/
--
View this message in context: http://www.nabble.com/pg_comparator-table-diff-sync-tf3730954.html#a10636792
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.