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@xxxxxxxxxx> 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@xxxxxxxx> 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@xxxxxxxxxxxxxx)
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
OmniTI Computer Consulting Inc.
Database Architect,
http://omniti.com/does/data-management
