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 BE2DB563A8; Mon, 7 Mar 2005 13:06:43 +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 48273-06; Mon, 7 Mar 2005 13:06:36 +0000 (GMT) Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180]) by svr1.postgresql.org (Postfix) with ESMTP id AAFD4563E6; Mon, 7 Mar 2005 13:06:35 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J208d.j.pppool.de [85.74.32.141]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 2E202A81D2; Mon, 7 Mar 2005 14:06:40 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 0AC99AB3D9; Mon, 7 Mar 2005 14:06:37 +0100 (CET) Message-ID: <422C51DC.5050408@logix-tt.com> Date: Mon, 07 Mar 2005 14:06:36 +0100 From: Markus Schaber Organization: Logical Tracking&Tracing International AG User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Stef Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Postgres schema comparison. References: <20050307113312.2200b65c@svb.ucs.co.za> <422C42B7.1030509@logix-tt.com> <20050307145444.459e54fe@svb.ucs.co.za> In-Reply-To: <20050307145444.459e54fe@svb.ucs.co.za> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------040402070005040005080507" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/79 X-Sequence-Number: 16577 This is a multi-part message in MIME format. --------------040402070005040005080507 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, Stef, Stef schrieb: > The problem I have with this, is that I have to run the command per table, > and seeing that I have over 500 tables in each database, this takes quite a > long time. Some weeks ago, I posted here a script that uses psql to create split dumps. Maybe you can reuse some of its logics to create per-table md5sums for all tables in a database automatically. Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org --------------040402070005040005080507 Content-Type: application/x-shellscript; name="dump_split.sh" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="dump_split.sh" IyEvYmluL2Jhc2gKIwojIChDKSAyMDA1IE1hcmt1cy5TY2hhYmVyQGxvZ2ktdHJhY2suY29t CiMKIyBUaGlzIGZpbGUgaXMgZnJlZSBzb2Z0d2FyZSBhbmQgbGljZW5zZWQgdW5kZXIgdGhl IEdOVSBHUEwuCiMKIyBLbm93biB3ZWFrbmVzc2VzOgojIC0gSSdtIG5vdCBzaHVyZSB3aGV0 aGVyIHRhYmxlcyBhbmQgc2VxdWVuY2VzIGFyZSB0aGUgb25seSB0aGluZyB0aGF0IGlzCiMg ICBpZ25vcmVkIGJ5IHBnX2R1bXAgLS1zY2hlbWFfb25seQojIC0ganVzdCBsaWtlIHBnX2R1 bXAsIGl0IGRvZXMgbm90IGR1bXAgbGFyZ2Ugb2JqZWN0cwojIC0gc2VxdWVuY2UgZGF0YSBp cyBhbHNvIGJ6aXBwZWQsIGFsdGhvdWdoIGl0IGlzIG5vdCB3b3J0aCB0aGUgZWZmb3J0Lgoj CiMgJElkOiBkdW1wX3NwbGl0LnNoLHYgMS40IDIwMDUvMDEvMjYgMTY6MTY6NTAgc2NoYWJp IEV4cCAkCgppZiBbIC16ICQyIF07ICB0aGVuIAoJZWNobyB1c2FnZTogJDAgYmFzZW5hbWUg ZGF0YWJhc2UKCWV4aXQKZmkKCkJBU0VOQU1FPSQxCkRBVEFCQVNFPSQyCgojIGZpcnN0IGR1 bXAgdGhlIHNjaGVtYS4KcGdfZHVtcCAtdiAtLXNjaGVtYS1vbmx5ICREQVRBQkFTRSAtZiAk e0JBU0VOQU1FfS1zY2hlbWEuc3FsCgojIFNlbGVjdCAic2NoZW1hbmFtZSB8IHRhYmxlbmFt ZSIgZm9yIGFsbCBub24tc3lzdGVtIHRhYmxlcyBhbmQgc2VxdWVuY2VzLgojIFBpcGUgdGhp cyBpbnRvIGFuIGF3ayBza3JpcHQgdGhhdCBvdXRwdXRzIHRoZSBhcHByb3ByaWF0ZSBjb21t YW5kcyBmb3IgZXZlcnkKIyBub24tZW1wdHkgbGluZS4KIyBQaXBlIHRoZSByZXN1bHQgaW50 byBhIHNoZWxsIHRoYXQgZXhlY3V0ZXMgdGhvc2UgY29tbWFuZHMKCnBzcWwgLXEgLXQgLWMg IlNFTEVDVCBuLm5zcG5hbWUgYXMgU2NoZW1hLCBjLnJlbG5hbWUgYXMgTmFtZSBGUk9NIHBn X2NhdGFsb2cucGdfY2xhc3MgYyBMRUZUIEpPSU4gcGdfY2F0YWxvZy5wZ19uYW1lc3BhY2Ug biBPTiBuLm9pZCA9IGMucmVsbmFtZXNwYWNlIFdIRVJFIGMucmVsa2luZCBJTiAoJ3InLCdT JykgQU5EIG4ubnNwbmFtZSBOT1QgSU4gKCdwZ19jYXRhbG9nJywgJ3BnX3RvYXN0JywnaW5m b3JtYXRpb25fc2NoZW1hJykgT1JERVIgQlkgMSwyIiAkREFUQUJBU0UgfCBhd2sgIlwkMyAg e3ByaW50IFwicGdfZHVtcCAtdiAtLXRhYmxlPVwiIFwkMyBcIiAtLXNjaGVtYSBcIiBcJDEg XCIgLS1kYXRhLW9ubHkgJERBVEFCQVNFIHwgYnppcDIgLTkgPiRCQVNFTkFNRS5cIiBcJDEg XCIuXCIgXCQzIFwiLnNxbC5iejJcIiB9IiB8IGJhc2gK --------------040402070005040005080507--