From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_restore: warning: invalid creation date in header
Date: Sun, 13 Jun 2021 12:12:25 -0400
Message-ID: <52961.1623600745@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOC+FBXMZaRa7msrbCshJPLyA7i17n_=a4DhLiHZZEqesncwKw@mail.gmail.com>
References: <CAOC+FBWDhDHO7G-i1_n_hjRzCnUeFO+H-Czi1y10mFhRWpBrew@mail.gmail.com>
<50545.1623597209@sss.pgh.pa.us>
<52307.1623599837@sss.pgh.pa.us>
<CAOC+FBXMZaRa7msrbCshJPLyA7i17n_=a4DhLiHZZEqesncwKw@mail.gmail.com>
Wells Oliver <wells.oliver@gmail.com> writes:
> Tom, it's a directory format dump, what file would make the most sense to
> run oc on? Or does this not work w/a directory?
The toc.dat file. You should see something like
$ od -c mydump/toc.dat | head
0000000 P G D M P 001 016 \0 004 \b 003 001 001 \0 \0 \0
0000020 \0 027 \0 \0 \0 \0 \n \0 \0 \0 \0 \f \0 \0 \0 \0
0000040 \r \0 \0 \0 \0 005 \0 \0 \0 \0 y \0 \0 \0 \0 001
0000060 \0 \0 \0 \0 \n \0 \0 \0 r e g r e s s i
0000100 o n \0 \a \0 \0 \0 1 4 b e t a 1 \0 \a
0000120 \0 \0 \0 1 4 b e t a 1 \0 315 \b \0 \0 \0
0000140 u 037 \0 \0 \0 \0 \0 \0 \0 \0 001 \0 \0 \0 0 \0
0000160 001 \0 \0 \0 0 \0 \b \0 \0 \0 E N C O D I
0000200 N G \0 \b \0 \0 \0 E N C O D I N G \0
0000220 002 \0 \0 \0 \0 # \0 \0 \0 S E T c l i
If there's not a "PGDMP" signature at the start then it's the wrong
file.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, wells.oliver@gmail.com
Subject: Re: pg_restore: warning: invalid creation date in header
In-Reply-To: <52961.1623600745@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox