1
I tried using meld
on two dumps from two different databases from the same RDBMS, but it seems that those dumps are not comparable because not being canonical.
I tried both pg_dump ...
(standard) and pg_dump -a ...
(only data) but both seem not being canonical, they are not so different, but the side to side difference shows a lot of false positives.
I searched for an applicable option in pg_dump
without success, maybe a special tool is needed for this?
Every db platform I've worked with required an external utility for this purpose, and Postgre is probably no differant. check this out: http://www.devart.com/dbforge/postgresql/datacompare/
– Frank Thomas – 2014-10-14T07:27:59.367Okay, but maybe for
pg_dump
maintainer adding an option for canonical output would be no big deal. Ifmeld
is OK, and it is, isn't it the natural approach trying to leverage it? – 174140 – 2014-10-14T07:50:11.000