Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Frost
Subject Re: Comparing two PostgreSQL databases -- order of pg_dump output
Date
Msg-id 20110830231107.GM12765@tamriel.snowman.net
Whole thread Raw
In response to Comparing two PostgreSQL databases -- order of pg_dump output  (Joe Abbate <jma@freedomcircle.com>)
Responses Re: Comparing two PostgreSQL databases -- order of pg_dump output
Re: Comparing two PostgreSQL databases -- order of pg_dump output
List pgsql-hackers
Tree view 
* 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

It also offers a whole slew of other useful things to monitor.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Joe Abbate
Date:
Subject: Re: Comparing two PostgreSQL databases -- order of pg_dump output
Next
From: Tom Lane
Date:
Subject: Re: spinlocks on HP-UX