Re: Comparing two databases for differences

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Comparing two databases for differences
Date: 2014-12-10 23:37:26
Message-ID: 1418254646.14352.1.camel@asus-laptop-03.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On Wed, 2014-12-10 at 14:08 +0000, Ferrell, Denise CTR NSWCDD, Z11
wrote:
> Does anyone know of an easy way to compare 2 database instances?
> Especially the stored procedures and tables from the two databases.

You can use pg_comparator -- also available in YUM repository.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Matthieu Lejeune 2014-12-12 16:22:29 Re: Problem pg_upgradecluster from 9.1 to 9.3
Previous Message Iñigo Salvat 2014-12-10 21:56:09 Data Masking