Re: pg_dump custom format without timestamp?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump custom format without timestamp?
Date: 2012-08-03 14:10:07
Message-ID: 16175.1344003007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> 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".

I'm not sure about this goal ...

> 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.

... and quite dislike this solution. pg_dump has way too many bizarre
options already. Perhaps you should consider making a bit of code that
knows how to compare two custom dumps ignoring the timestamp.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-08-03 14:33:21 Re: WIP pgindent replacement
Previous Message Bruce Momjian 2012-08-03 14:03:18 Re: WIP pgindent replacement