Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group