Re: Comparing two PostgreSQL databases -- order of pg_dump output

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Joe Abbate <jma(at)freedomcircle(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Comparing two PostgreSQL databases -- order of pg_dump output
Date: 2011-08-30 23:11:07
Message-ID: 20110830231107.GM12765@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Joe Abbate (jma(at)freedomcircle(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-08-30 23:21:48 Re: spinlocks on HP-UX
Previous Message Joe Abbate 2011-08-30 23:07:21 Re: Comparing two PostgreSQL databases -- order of pg_dump output