Re: pg_restore: warning: invalid creation date in header

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_restore: warning: invalid creation date in header
Date: 2021-06-13 15:57:17
Message-ID: 52307.1623599837@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wrote:
> Hmm. Looking at the code for that, it knows nothing of timezones.
> It's complaining that mktime() failed, which perhaps is because of
> bad data in the archive header ... but I'm betting it has something
> to do with failing to initialize all the fields of the struct tm
> it passes.

After reading the mktime man page, I take that back --- it's not
supposed to consider the passed-in values of the tm_wday and tm_yday
fields. The only documented reason for mktime to fail is if the
supplied values map to something outside the range of time_t,
which seems a tad unlikely. It'd be interesting perhaps to see
the raw header of your dump file, along the lines of
"od -c dumpfile | head".

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2021-06-13 16:02:41 Re: pg_restore: warning: invalid creation date in header
Previous Message Wells Oliver 2021-06-13 15:37:34 pg_restore & locks