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 C141F3AB199 for ; Tue, 21 Dec 2004 00:00:25 +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 33809-03 for ; Tue, 21 Dec 2004 00:00:18 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id B22A13AB1B3 for ; Tue, 21 Dec 2004 00:00:17 +0000 (GMT) thread-index: AcTm8BYkWkpLCleURqiwLAeX5L6vRQ== Received: from [192.168.1.103] ([24.211.121.176]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 20 Dec 2004 19:00:30 -0500 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Message-ID: <41C76824.1030904@sermonaudio.com> Date: Mon, 20 Dec 2004 19:02:44 -0500 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.8 (X11/20040920) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Rosser Schwarz" , Subject: Re: Any tools to compare db's References: <37d451f70412200944b09c7d4@mail.gmail.com> In-Reply-To: <37d451f70412200944b09c7d4@mail.gmail.com> X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 21 Dec 2004 00:00:31.0078 (UTC) FILETIME=[161D6060:01C4E6F0] 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: 200412/206 X-Sequence-Number: 15792 That really does not work. It will tell you line by line differences, but not what object it is. Also, it does not help to generate the sql to sync the db's. Chris Rosser Schwarz wrote: >while you weren't looking, Chris Hoover wrote: > =20 > >>Does anyone know of any good tools that will compare 2 db's and = generate a complete listing of any object differences? =20 >> =20 >> > >Perhaps something like: > >$ pg_dump --schema-only db1 > db1.sql >$ pg_dump --schema-only db2 > db2.sql >$ diff db1.sql db2.sql > >would accomplish what you're after? It does specifically list GRANTs, >among other things. > >/rls > > =20 >