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 625945650D for ; Tue, 8 Mar 2005 08:59:27 +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 94917-02 for ; Tue, 8 Mar 2005 08:59:21 +0000 (GMT) Received: from mail2.fluidhosting.com (mail2.fluidhosting.com [66.150.201.102]) by svr1.postgresql.org (Postfix) with SMTP id 7B93456534 for ; Tue, 8 Mar 2005 08:59:20 +0000 (GMT) Received: (qmail 60671 invoked by uid 399); 8 Mar 2005 08:56:57 -0000 Received: from unknown (HELO mail1.fluidhosting.com) (66.150.201.101) by mail2.fluidhosting.com with SMTP; 8 Mar 2005 08:56:57 -0000 Received: (qmail 70842 invoked by uid 399); 8 Mar 2005 08:59:20 -0000 Received: from unknown (HELO ?127.0.0.1?) (194.185.112.82) by mail1.fluidhosting.com with SMTP; 8 Mar 2005 08:59:20 -0000 Message-ID: <422D6968.4070000@beccati.com> Date: Tue, 08 Mar 2005 09:59:20 +0100 From: Matteo Beccati User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stef Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Postgres schema comparison. References: <20050307113312.2200b65c@svb.ucs.co.za> In-Reply-To: <20050307113312.2200b65c@svb.ucs.co.za> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/113 X-Sequence-Number: 16611 Hi, > 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. I've made a simple PHP script which compares the schemas of two databases. It was made in a hurry and is far from being complete, but it works for my purposes :) If you want give it a try, let me know Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com