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 8C08C560F2;
	Mon,  7 Mar 2005 09:33:35 +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 86747-08; Mon,  7 Mar 2005 09:33:29 +0000 (GMT)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 53C5252A7A;
	Mon,  7 Mar 2005 09:33:18 +0000 (GMT)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 275BD2BD64;
	Mon,  7 Mar 2005 11:33:16 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP
	id 11C8FD9F2C; Mon,  7 Mar 2005 11:33:12 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with ESMTP id 4D0CF973EC;
	Mon,  7 Mar 2005 11:33:12 +0200 (SAST)
Date: Mon, 7 Mar 2005 11:33:12 +0200
From: Stef <svb@ucs.co.za>
To: pgsql-ADMIN@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Postgres schema comparison.
Message-ID: <20050307113312.2200b65c@svb.ucs.co.za>
X-Mailer: Sylpheed-Claws 1.0.1 (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YE<S+T;
	pGztI>WH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.492 tagged_above=0 required=5
	tests=DNS_FROM_RFC_WHOIS
X-Spam-Level: 
X-Archive-Number: 200503/73
X-Sequence-Number: 16571

Hi all,

I've got a master database with many other databases that
all have (or is supposed to have) the same exact same schema 
as the master database (the master database is basically an empty 
template database containing the schema definition).

The problem is that none of the schemas actually match the master schema.
e.g. missing columns, columns not in the correct order (attnum), missing indexes
and primary keys, and in severe cases, missing sequences and tables.

I have the wonderful job of re-synch'ing  all the schemas out there not
conforming to the master. I've looked everywhere for something that 
will help doing this. I'm specifically looking for a way to do a sumcheck
or something similar on tables and/or schema as a whole to be able to
do a table comparison with the master database.

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.

TIA
Kind Regards
Stefan