Re: compare two schemas

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: compare two schemas
Date: 2010-03-07 10:48:53
Message-ID: 1267958933.2305.4.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2010-03-07 at 16:40 +0600, AI Rumman wrote:
> I have to compare two schamas in two different Postgresql databases to
> identify the mismatch between the production and development
> environment
> databases.
>
> Is there any good tool?

http://bucardo.org/wiki/Check_postgres

check_postgres does this. See same_schema option.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-03-07 11:11:09 Re: XML Index again
Previous Message Adrian von Bidder 2010-03-07 10:44:19 Re: non intuitive behaviour of DROP TABLE IF EXISTS