That really does not work. It will tell you line by line differences,
but not what object it is. Also, it does not help to generate the sql
to sync the db's.
Rosser Schwarz wrote:
>while you weren't looking, Chris Hoover wrote:
>>Does anyone know of any good tools that will compare 2 db's and generate a complete listing of any object differences?
>Perhaps something like:
>$ pg_dump --schema-only db1 > db1.sql
>$ pg_dump --schema-only db2 > db2.sql
>$ diff db1.sql db2.sql
>would accomplish what you're after? It does specifically list GRANTs,
>among other things.
In response to
pgsql-admin by date
|Next:||From: Rosser Schwarz||Date: 2004-12-21 04:46:46|
|Subject: Re: Any tools to compare db's|
|Previous:||From: Artur Pietruk||Date: 2004-12-20 22:42:09|
|Subject: Re: PostgreSQL internals and implementation of transactions|