Re: pg_dumpall + pgdump_oid table + incremental backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: weigelt(at)metux(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall + pgdump_oid table + incremental backup
Date: 2009-04-19 16:50:20
Message-ID: 15627.1240159820@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Enrico Weigelt <weigelt(at)metux(dot)de> writes:
> I'd like to do hourly incremental backups w/ pg_dumpall + git.
> But each time I dump out an unchanged data, I get differences
> on the temporary pgdump_oid table, which seems to be used to
> ensure correct OIDs. This most likely useless change will
> unnecessarily fill up my backup.

> Is there any way around this ?

Well, you could not use -o, or you could move to a less obsolete
version of Postgres ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Maria L. Wilson 2009-04-20 17:49:29 postgres 8.2.9 transaction id wraparound failure
Previous Message Enrico Weigelt 2009-04-19 16:33:46 pg_dumpall + pgdump_oid table + incremental backup