Re: Comparing two PostgreSQL databases -- order of pg_dump output - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Comparing two PostgreSQL databases -- order of pg_dump output
Date
Msg-id 1314778306.27073.4.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Comparing two PostgreSQL databases -- order of pg_dump output  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On tis, 2011-08-30 at 19:11 -0400, Stephen Frost wrote:
> * Joe Abbate (jma@freedomcircle.com) wrote:
> > In order to compare the schema of two presumably identical
> > databases, I've been diffing the output of pg_dump -Osx.  
> 
> I'm not sure exactly how it does it, but check_postgres.pl offers this.
> 
> http://bucardo.org/wiki/Check_postgres

That tool is also not without bugs in this regard.

Also, the interface it works with necessarily doesn't offer a good way
to examine the differences in detail; it only shows you that there are
differences.




pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Inputting relative datetimes
Next
From: Peter Eisentraut
Date:
Subject: Re: Comparing two PostgreSQL databases -- order of pg_dump output