Postgres Pro
Downloads
Home   >   mailing lists

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

From Wells Oliver
Subject Re: pg_restore: warning: invalid creation date in header
Date
Msg-id CAOC+FBXLMUW2dqpckEXKsK7Y_r7gsYhXJ78m6vdGtqRXM_JOmg@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore: warning: invalid creation date in header  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
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@gmail.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.


--

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: pg_restore: warning: invalid creation date in header
Next
From: Nikhil Shetty
Date:
Subject: Re: vacuumdb idle processes