Re: Any tools to compare db's

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Chris Hoover <revoohc(at)sermonaudio(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Any tools to compare db's
Date: 2004-12-20 17:44:05
Message-ID: 37d451f70412200944b09c7d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-12-20 19:01:09 Re: From latin9 to sql_ascii??
Previous Message Helena Lourenco 2004-12-20 17:23:02 unsubscribe pgsql-bugs