Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparing two databases for differences - Mailing list pgsql-admin

From Denish Patel
Subject Re: Comparing two databases for differences
Date
Msg-id CAFddxvOo+mp2aV70bTkb4D5xcbmkE8NSbZxvkQSY7VigCTKF9Q@mail.gmail.com
Whole thread Raw
In response to Comparing two databases for differences  ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
Responses Re: Comparing two databases for differences
List pgsql-admin
Tree view
The easiest way to compare schema by using https://github.com/omniti-labs/pg_extractor to dump objects into separate git repo for each database and look for difference in both repos. 

On Wed, Dec 10, 2014 at 9:08 AM, Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil> wrote:
Running PostgreSQL 9.3.5 on Linux.

Does anyone know of an easy way to compare 2 database instances?  Especially the stored procedures and tables from the two databases.

Thank you in advance.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Denish Patel,
OmniTI Computer Consulting Inc.
Database Architect,
http://omniti.com/does/data-management

pgsql-admin by date:

Previous
From: "Ferrell, Denise CTR NSWCDD, Z11"
Date:
Subject: Comparing two databases for differences
Next
From: Stephen Frost
Date:
Subject: Re: Comparing two databases for differences