Re: Any tools to compare db's - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: Any tools to compare db's
Date
Msg-id 37d451f70412200944b09c7d4@mail.gmail.com
Whole thread Raw
In response to Any tools to compare db's  ("Chris Hoover" <revoohc@sermonaudio.com>)
Responses Re: Any tools to compare db's
List pgsql-admin
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.

/rls

--
:wq

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Any tools to compare db's
Next
From: Artur Pietruk
Date:
Subject: Re: PostgreSQL internals and implementation of transactions