Postgres Pro
Downloads
Home   >   mailing lists

pg_dumpall + pgdump_oid table + incremental backup - Mailing list pgsql-admin

From Enrico Weigelt
Subject pg_dumpall + pgdump_oid table + incremental backup
Date
Msg-id 20090419163346.GB6657@nibiru.local
Whole thread Raw
Responses Re: pg_dumpall + pgdump_oid table + incremental backup
List pgsql-admin
Tree view 
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/
---------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange behaviour with a query
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall + pgdump_oid table + incremental backup