X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5F819D1CA83 for ; Sun, 29 Feb 2004 03:19:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07645-04 for ; Sat, 28 Feb 2004 23:19:29 -0400 (AST) Received: from keow.org (unknown [69.41.247.100]) by svr1.postgresql.org (Postfix) with SMTP id B86F1D1BB15 for ; Sat, 28 Feb 2004 23:19:24 -0400 (AST) Received: (qmail 26915 invoked by uid 1000); 29 Feb 2004 03:22:44 -0000 Date: Sun, 29 Feb 2004 03:22:44 +0000 From: Tim Larson To: pgsql-hackers@postgresql.org Subject: Re: [ADMIN] Schema comparisons Message-ID: <20040229032244.GE24612@keow.org> References: <25377.1077942505@sss.pgh.pa.us> <4F7D4521-69BC-11D8-ACD3-000A9579AF50@indeq.com> <27965.1077982780@sss.pgh.pa.us> <20040229022348.GL8646@posixnap.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040229022348.GL8646@posixnap.net> User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/980 X-Sequence-Number: 50569 On Sat, Feb 28, 2004 at 09:23:48PM -0500, Alex J. Avriette wrote: > On Sat, Feb 28, 2004 at 10:39:40AM -0500, Tom Lane wrote: > > > >> Have you tried diffing pg_dump output? It's not the greatest tool but > > >> it's helpful. > > > > > Yes, I did. It was quite cumbersome. Especially since the OIDs and > > > TOC entry numbers didn't matchup; and, since those didn't always match, > > > the order of objects wasn't quite the same either. So, diff was > > > throwing a lot of false positives at me. > > > > Yeah. CVS-tip pg_dump doesn't show OIDs by default, to make it easier > > to use for purposes like this. The ordering issue is the bigger problem > > though. I presume that the object creation history is different in the > > two databases and so pg_dump's habit of sorting by OID isn't helpful. > > I recently had to figure out what was different between the "live" schema > and the schema in cvs at work. This was a really painful process, and it > occurred to me that it wouldn't be terribly hard to write a perl program > to do it (I wound up using vim and diff). Is there interest in such a tool? > I could probably have one written within a day or two. I sometimes supplement vim/diff with xxdiff, meld, and winmerge. Hope this helps someone, --Tim Larson