Обсуждение: dump diffs even w/o db changes
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/ ---------------------------------------------------------------------
Enrico Weigelt <weigelt@metux.de> writes: > 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). > CREATE TEMPORARY TABLE pgdump_oid (dummy integer) WITH OIDS; > COPY pgdump_oid WITH OIDS FROM stdin; > -22336387 0 > Is there any way to get rid of these differences ? (1) don't specify --oids or (2) update to something newer than 8.0 ... we haven't emitted that for a long time. regards, tom lane