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 32496528BE for ; Wed, 8 Jun 2005 09:09:33 -0300 (ADT) 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 06718-01 for ; Wed, 8 Jun 2005 12:09:24 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.205]) by svr1.postgresql.org (Postfix) with ESMTP id 1052452849 for ; Wed, 8 Jun 2005 09:09:23 -0300 (ADT) Received: by rproxy.gmail.com with SMTP id 34so29398rns for ; Wed, 08 Jun 2005 05:09:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=AD1E6qu2FYSujIM5Kh64iRs/F0JQtjboVE/2mE4PSFTIC3+zSphPe+RIzTwIk3EIi+iIyn5CVDqsdJIFfeQo/GBn4vu0Wl8yr2YvwO10Qd5pv8JRT/ovWSu42S5Bzoic3klF1BzguulIoBhO6jBFG+mTbN13YdboSvC6JpoPH/A= Received: by 10.38.8.46 with SMTP id 46mr31575rnh; Wed, 08 Jun 2005 05:09:26 -0700 (PDT) Received: by 10.38.8.15 with HTTP; Wed, 8 Jun 2005 05:09:26 -0700 (PDT) Message-ID: Date: Wed, 8 Jun 2005 14:09:26 +0200 From: Fredrik Olsson Reply-To: Fredrik Olsson To: pgsql-admin@postgresql.org Subject: Schema diffs Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/41 X-Sequence-Number: 17796 Hello. I run a database on two separate servers, one development/test server and one production server. The production database is updated quite often, and the development database is naturally used to quality test changes before deployment. For small changes manual updates are no problem. For major updates it has proven to be cumbersome. I have searched the webb with google for some time now in search of a usable diff tool for the database schemas. So far the only free tool I have been able to locate is part of the much larger system ez publish. It seems like a major overkill for my needs. Is there any available, preferably free tool that can be used to make diffs usable to update a production database in parallel of a development database as I have described? best regards Fredrik Olsson