Re: pg_restore: warning: invalid creation date in header - Mailing list pgsql-admin

From Ron
Subject Re: pg_restore: warning: invalid creation date in header
Date
Msg-id 58342210-77b5-421a-30ed-a0a47570c7e6@gmail.com
Whole thread Raw
In response to pg_restore: warning: invalid creation date in header  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: pg_restore: warning: invalid creation date in header
List pgsql-admin
On 6/12/21 6:47 PM, Wells Oliver wrote:
These are the first lines when trying to restore a dump created on a machine in the PDT time zone, into a machine in UTC. Not sure if it matters, but I wanted to ask.

pg_restore: warning: invalid creation date in header
pg_restore: while PROCESSING TOC:

Given that it's just a warning, did the restore complete?

As for the reason... since PDT is -7 to UTC, I bet the creation date is less than the clock date, which pg_restore warns about.

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: pg_restore: warning: invalid creation date in header
Next
From: Wells Oliver
Date:
Subject: Re: pg_restore: warning: invalid creation date in header