X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3C789D1B4DC for ; Sat, 28 Feb 2004 04:28:45 +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 27306-08 for ; Sat, 28 Feb 2004 00:28:28 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B1F51D1B4AA for ; Sat, 28 Feb 2004 00:28:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1S4SQsZ025378; Fri, 27 Feb 2004 23:28:26 -0500 (EST) To: Mark Lubratt Cc: pgsql-admin@postgresql.org Subject: Re: Schema comparisons In-reply-to: References: Comments: In-reply-to Mark Lubratt message dated "Fri, 27 Feb 2004 21:32:43 -0600" Date: Fri, 27 Feb 2004 23:28:25 -0500 Message-ID: <25377.1077942505@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/391 X-Sequence-Number: 12564 Mark Lubratt writes: > I've been trying to be careful, but I've gotten out of synch with > whether or not I've applied the changes I've made to the development > system to the production system. Is there a utility that will compare > the tables, functions, trigger, views, etc. between two systems and > flag the schema elements that aren't in synch between the two? Have you tried diffing pg_dump output? It's not the greatest tool but it's helpful. regards, tom lane