Re: dump diffs even w/o db changes - Mailing list pgsql-admin

From Tom Lane
Subject Re: dump diffs even w/o db changes
Date
Msg-id 13387.1272652781@sss.pgh.pa.us
Whole thread Raw
In response to dump diffs even w/o db changes  (Enrico Weigelt <weigelt@metux.de>)
List 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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Next
From: Tom Lane
Date:
Subject: Re: Fresh build on OS X not working (memory)