| From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dumpall + pgdump_oid table + incremental backup |
| Date: | 2009-04-19 16:33:46 |
| Message-ID: | 20090419163346.GB6657@nibiru.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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/
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-04-19 16:50:20 | Re: pg_dumpall + pgdump_oid table + incremental backup |
| Previous Message | Tom Lane | 2009-04-17 14:37:18 | Re: Strange behaviour with a query |