Re: Comparing two databases for differences

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(at)omniti(dot)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(dot)ferrell(dot)ctr(at)navy(dot)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(at)postgresql(dot)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
> http://www.pateldenish.com
>

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