Thread: pg_dumpall + pgdump_oid table + incremental backup

Hi folks,

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 ?


thx
--
---------------------------------------------------------------------
 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'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