Re: pg_restore: warning: invalid creation date in header

That's what I figured. Restore looks fine. Just hadn't seen that before
(but also never had restored a PDT backup to a UTC machine). Just wanted to
check.

On Sat, Jun 12, 2021 at 4:57 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

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

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>