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.