pg_dump custom format without timestamp?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump custom format without timestamp?
Date: 2012-08-03 08:54:16
Message-ID: alpine.DEB.2.02.1208030901380.16384@localhost6.localdomain6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello,

I was looking into using hardlinks to reduce the storage of keeping and
syncing periodic database dumps when they are identical. This works fine
with the textual format, but not for the custom format because the file
header includes a timestamp set by function WriteHead in file
"src/bin/pg_dump/pg_backup_archiver.c".

In order to circumvent this issue, I would think of adding a
"--no-timestamp" option to pg_dump and put zeros everywhere in place of
the actual timestamp in such case, and possibly ignoring the said
timestamp in function ReadHead.

Any thoughts about this?

--
Fabien.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2012-08-03 09:02:51 Re: [PATCH] Make "psql -1 < file.sql" work as with "-f"
Previous Message Robert Haas 2012-08-03 08:28:42 Re: Git diff patch in context diff format