Re: [HACKERS] pg_comparator table diff/sync
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. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] pg_comparator table diff/sync
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
Re: [HACKERS] pg_comparator table diff/sync
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. Andrew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] pg_comparator table diff/sync
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 [EMAIL PROTECTED]: 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. 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