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

From Tom Lane
Subject Re: pg_dumpall + pgdump_oid table + incremental backup
Date
Msg-id 15627.1240159820@sss.pgh.pa.us
Whole thread Raw
In response to pg_dumpall + pgdump_oid table + incremental backup  (Enrico Weigelt <weigelt@metux.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Enrico Weigelt
Date:
Subject: pg_dumpall + pgdump_oid table + incremental backup
Next
From: "Maria L. Wilson"
Date:
Subject: postgres 8.2.9 transaction id wraparound failure