On Monday 12 April 2004 22:38, you wrote:
> ${PG_DUMP} -s -p 5432 mydb|${GREP} -v '^--'|${CAT} -s >5432.sql
> ${PG_DUMP} -s -p 5433 mydb|${GREP} -v '^--'|${CAT} -s >5433.sql
> ${PG_DUMP} -s -p 5434 mydb|${GREP} -v '^--'|${CAT} -s >5434.sql
>
> ${DIFF} 5432.sql 5433.sql > 5432-5433.diff
> ${DIFF} 5433.sql 5434.sql > 5433-5434.diff
I used to do exactly this but the pg_dump order is different on my two
servers, and this generates lots of false diffs.
Here's a link to my really simple script which does what I want:
http://carcass.ath.cx/diffpg.pl
It doesn't honor schema and object ownership.
--
Best regards,
Igor Shevchenko