pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
dump diffs even w/o db changes
2+ messages / 2 participants
[nested] [flat]


* dump diffs even w/o db changes
@ 2010-04-30 16:14  Enrico Weigelt <weigelt@metux.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Enrico Weigelt @ 2010-04-30 16:14 UTC (permalink / raw)
  To: pgsql-admin

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). 


inline patch 1: DB-net79.sql (+0/-0 lines) download inline-1.patchdiff --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/
---------------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: dump diffs even w/o db changes
@ 2010-04-30 18:39  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Enrico Weigelt <weigelt@metux.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2010-04-30 18:39 UTC (permalink / raw)
  To: weigelt@metux.de; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-04-30 18:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-30 16:14 dump diffs even w/o db changes Enrico Weigelt <weigelt@metux.de>
2010-04-30 18:39 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox