| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | weigelt(at)metux(dot)de |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: dump diffs even w/o db changes |
| Date: | 2010-04-30 18:39:41 |
| Message-ID: | 13387.1272652781@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Enrico Weigelt <weigelt(at)metux(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-04-30 21:35:34 | Re: Fresh build on OS X not working (memory) |
| Previous Message | Kevin Grittner | 2010-04-30 18:21:08 | Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3 |