X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C341955CEE;
	Mon,  7 Mar 2005 12:02:15 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 33208-02; Mon,  7 Mar 2005 12:02:06 +0000 (GMT)
Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180])
	by svr1.postgresql.org (Postfix) with ESMTP id DEAC7563D8;
	Mon,  7 Mar 2005 12:02:05 +0000 (GMT)
Received: from kingfisher.intern.logi-track.com (J208d.j.pppool.de
	[85.74.32.141])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id D9A5DA81D2;
	Mon,  7 Mar 2005 13:02:04 +0100 (CET)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 6BB6AAB3D9;
	Mon,  7 Mar 2005 13:02:00 +0100 (CET)
Message-ID: <422C42B7.1030509@logix-tt.com>
Date: Mon, 07 Mar 2005 13:01:59 +0100
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking&Tracing International AG
User-Agent: Mozilla Thunderbird 1.0 (X11/20050116)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
To: Stef <svb@ucs.co.za>
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
References: <20050307113312.2200b65c@svb.ucs.co.za>
In-Reply-To: <20050307113312.2200b65c@svb.ucs.co.za>
X-Enigmail-Version: 0.90.1.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200503/75
X-Sequence-Number: 16573

Hi, Stef,

Stef schrieb:

> It will be a bonus to pick up exactly what is missing, but for now, just identifying 
> differences is what I want to achieve. I'm using postgres 7.3 mostly, but
> I may want to use this for 7.4 and 8.0 databases as well. 
> 
> Has anybody got some suggestions of what I can do or use to do this.

There are (at least) two independently developed pgdiff applications,
they can be found at:

http://pgdiff.sourceforge.net/

http://gborg.postgresql.org/project/pgdiff/projdisplay.php

I did not try the first one, but the latter one worked on some of my
datas, but fails on others. I filed a bug report some time ago, but got
no answer, so I'm afraid this tool currently is unmaintained:
http://gborg.postgresql.org/project/pgdiff/bugs/bugupdate.php?895

But maybe a pg_dump --schema-only on all the databases, and then
manually diffing the files may already fulfil your needs.


Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org