On 08/30/2011 07:11 PM, Stephen Frost wrote:
> * 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.
> It also offers a whole slew of other useful things to monitor.
Note that what I'm looking for is something to compare just about
EVERYTHING DDL under the PostgreSQL sun: tables, types, functions,
operators, etc. The description of same_schema appears to imply only a
subset of objects are compared (in fact, looking at the code, I can
confirm that limitation).
BTW, I tried installing check_postgres, but not being much into Perl and
not knowing what dependencies it has, "make test" failed 38/42 tests.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2011-08-31 00:29:37|
|Subject: Re: spinlocks on HP-UX |
|Previous:||From: Robert Haas||Date: 2011-08-30 23:48:45|
|Subject: Re: spinlocks on HP-UX|