Re: pg_restore: warning: invalid creation date in header

0000000 P G D M P 001 016 \0 004 \b 003 001 001 \0 \0 \0
0000020 \0 4 \0 \0 \0 \0 - \0 \0 \0 \0 \t \0 \0 \0 \0
0000040 \v \0 \0 \0 \0 005 \0 \0 \0 \0 y \0 \0 \0 \0 001
0000060 \0 \0 \0 \0 \b \0 \0 \0 b o x s c o r e
0000100 \0 \0 \0 \0 1 3 . 2 ( U b u n t
0000120 u 1 3 . 2 - 1 . p g d g 1 8 .
0000140 0 4 + 1 ) \0 \0 \0 \0 1 3 . 2 (
0000160 U b u n t u 1 3 . 2 - 1 . p g
0000200 d g 1 8 . 0 4 + 1 ) \0 \t ! \0 \0 \0
0000220 E S \0 \0 \0 \0 \0 \0 \0 \0 001 \0 \0 \0 0 \0

On Sun, Jun 13, 2021 at 9:12 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Wells Oliver <wells(dot)oliver(at)gmail(dot)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
>

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