Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 08FC1632C95 for ; Fri, 30 Apr 2010 14:19:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84863-03 for ; Fri, 30 Apr 2010 17:19:21 +0000 (UTC) X-Greylist: delayed 00:06:09.901746 by SQLgrey-1.7.6 Received: from s15216962.onlinehome-server.info (forum.psychotherapie.org [217.160.22.205]) by mail.postgresql.org (Postfix) with ESMTP id 2EBAF632DF3 for ; Fri, 30 Apr 2010 14:19:20 -0300 (ADT) Received: (from uucp@localhost) by s15216962.onlinehome-server.info (8.13.3/8.13.3) with UUCP id o3UHD8XH028440 for pgsql-admin@postgresql.org; Fri, 30 Apr 2010 19:13:08 +0200 Received: (from weigelt@localhost) by nibiru.metux.de (8.12.10/8.12.10) id o3UGEkVk009080 for pgsql-admin@postgresql.org; Fri, 30 Apr 2010 18:14:46 +0200 Date: Fri, 30 Apr 2010 18:14:45 +0200 From: Enrico Weigelt To: pgsql-admin Subject: dump diffs even w/o db changes Message-ID: <20100430161443.GA24971@nibiru.local> Reply-To: weigelt@metux.de Mail-Followup-To: pgsql-admin Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Terror: bin laden, kill bush, Briefbombe, Massenvernichtung, KZ, X-Nazi: Weisse Rasse, Hitlers Wiederauferstehung, 42, X-Antichrist: weg mit schaeuble, ausrotten, heiliger krieg, al quaida, X-Killer: 23, endloesung, Weltuntergang, X-Doof: wer das liest ist doof X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201004/369 X-Sequence-Number: 34463 Hi folks, I'm doing regular (hourly) dumps and putting them into git (and automatically pushing it to several git servers). The problem is: the dumps are always differing (even if nothing happened in that db). diff --git a/DB-net79.sql b/DB-net79.sql index 89b682d..c8be6d6 100644 --- a/DB-net79.sql +++ b/DB-net79.sql @@ -12,7 +12,7 @@ SET client_min_messages = warning; CREATE TEMPORARY TABLE pgdump_oid (dummy integer) WITH OIDS; COPY pgdump_oid WITH OIDS FROM stdin; -22336387 0 +22336547 0 \. DROP TABLE pgdump_oid; This unnecessarily pollutes the history and procudes high load when git-gc / git-repack runs. Is there any way to get rid of these differences ? cu - --------------------------------------------------------------------- Enrico Weigelt == metux IT service - http://www.metux.de/ --------------------------------------------------------------------- Please visit the OpenSource QM Taskforce: http://wiki.metux.de/public/OpenSource_QM_Taskforce Patches / Fixes for a lot dozens of packages in dozens of versions: http://patches.metux.de/ ---------------------------------------------------------------------