Subject: Re: pg_restore: warning: invalid creation date in header
To: pgsql-admin@lists.postgresql.org
References: 
 <CAOC+FBWDhDHO7G-i1_n_hjRzCnUeFO+H-Czi1y10mFhRWpBrew@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <58342210-77b5-421a-30ed-a0a47570c7e6@gmail.com>
Date: Sat, 12 Jun 2021 18:57:24 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: 
 <CAOC+FBWDhDHO7G-i1_n_hjRzCnUeFO+H-Czi1y10mFhRWpBrew@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------D4E5BF3712F46BBFAC20308B"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/58342210-77b5-421a-30ed-a0a47570c7e6%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------D4E5BF3712F46BBFAC20308B
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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.

--------------D4E5BF3712F46BBFAC20308B
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 6/12/21 6:47 PM, Wells Oliver wrote:<br>
    <blockquote type="cite"
cite="mid:CAOC+FBWDhDHO7G-i1_n_hjRzCnUeFO+H-Czi1y10mFhRWpBrew@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">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.
        <div><br>
        </div>
        <div>pg_restore: warning: invalid creation date in header<br>
          pg_restore: while PROCESSING TOC:<br>
        </div>
      </div>
    </blockquote>
    <br>
    Given that it's just a warning, did the restore complete?<br>
    <br>
    As for the reason... since PDT is -7 to UTC, I bet the creation date
    is <b>less than</b> the clock date, which pg_restore warns about.<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------D4E5BF3712F46BBFAC20308B--