Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D070F9FB3FE for ; Wed, 6 Jun 2007 09:13:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 06807-05 for ; Wed, 6 Jun 2007 09:13:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from nabagan.bluegap.ch (nabagan.bluegap.ch [88.198.58.248]) by postgresql.org (Postfix) with ESMTP id F1E849FB408 for ; Wed, 6 Jun 2007 09:13:26 -0300 (ADT) Received: from [192.168.0.237] (berlin.programmfabrik.de [::ffff:213.221.101.147]) (AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits, AES256-SHA) by nabagan.bluegap.ch with esmtp; Wed, 06 Jun 2007 15:07:26 +0200 id 00001062.4666B18E.0000371B Message-ID: <4666A4AC.8020706@bluegap.ch> Date: Wed, 06 Jun 2007 14:12:28 +0200 From: Markus Schiltknecht User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: chester c young CC: sql pgsql Subject: Re: schema propagation References: <470697.16672.qm@web54304.mail.re2.yahoo.com> In-Reply-To: <470697.16672.qm@web54304.mail.re2.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/53 X-Sequence-Number: 28543 Hi, chester c young wrote: > has anyone done any work on comparing schemas? There are two different projects called 'pgdiff', you'll find them with google. > I'm trying to automatically propagate changes in a master schema to > child schemas. All schema changes will originate at master. Currently > child schemas are in the same database, but in the future might be in > different databases (clusters?). Please note, that it's sometimes impossible to automatically convert from one database schema to another. You should probably better use proper change management processes. Regards Markus