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 CAFddxvPTrb4HMzs=Lz1ecoz6SHsouN7ZUq=fVcW_QTjuhcD4hg@mail.gmail.com
Whole thread Raw
In response to Re: Comparing two databases for differences  (Denish Patel <denish@omniti.com>)
List pgsql-admin
Tree view
you don't have to use Git repo. Just dump objects using pg_extractors in two folders and run "diff" between them.

On Wed, Dec 10, 2014 at 9:13 AM, Denish Patel <denish@omniti.com> wrote:
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



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

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Comparing two databases for differences
Next
From: jaime soler
Date:
Subject: Re: Comparing two databases for differences