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 713E5563BC; Mon, 7 Mar 2005 13:03:58 +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 47611-09; Mon, 7 Mar 2005 13:03:53 +0000 (GMT) Received: from bos-gate2.raytheon.com (bos-gate2.raytheon.com [199.46.198.231]) by svr1.postgresql.org (Postfix) with ESMTP id 5AF43563AD; Mon, 7 Mar 2005 13:03:52 +0000 (GMT) Received: from ds02e00.directory.ray.com (ds02e00.directory.ray.com [147.25.130.245]) by bos-gate2.raytheon.com (8.12.10/8.12.10) with ESMTP id j27D3otn021876; Mon, 7 Mar 2005 08:03:50 -0500 (EST) Received: from ds02e00 (localhost [127.0.0.1]) by ds02e00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id j27D3mvj028430; Mon, 7 Mar 2005 13:03:48 GMT Received: from ds02e00.directory.ray.com with LMTP by ds02e00 (2.0.6/sieved-2-0-build-559); Mon, 7 Mar 2005 13:03:48 +0000 Received: from notesserver5.ftw.us.ray.com (notesserver5.ftw.us.ray.com [151.168.145.35]) by ds02e00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id j27D3iU9028407 sender Richard_D_Levine@raytheon.com; Mon, 7 Mar 2005 13:03:45 GMT Subject: Re: [SQL] Postgres schema comparison. To: John DeSoi Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org, pgsql-sql-owner@postgresql.org, Stef X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: Richard_D_Levine@raytheon.com Date: Mon, 7 Mar 2005 08:03:43 -0500 X-MIMETrack: Serialize by Router on NotesServer5/HDC(Release 6.5.2|June 01, 2004) at 03/07/2005 08:03:45 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-SPAM: 0.00 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.184 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200503/78 X-Sequence-Number: 16576 Are you just synching the schemas, or do you also need to synch the data? Rick John DeSoi To: Stef Sent by: cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org pgsql-sql-owner@pos Subject: Re: [SQL] [ADMIN] Postgres schema comparison. tgresql.org 03/07/2005 07:39 AM On Mar 7, 2005, at 4:33 AM, Stef wrote: > I have the wonderful job of re-synch'ing all the schemas out there not > conforming to the master. I've looked everywhere for something that > will help doing this. I'm specifically looking for a way to do a > sumcheck > or something similar on tables and/or schema as a whole to be able to > do a table comparison with the master database. > Develop a function that builds a string describing the tables/schemas you want to compare. Then have your function return the md5 sum of the string as the result. This will give you a 32 character value you can use to determine if there is a mismatch. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)