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

From Tom Lane
Subject Re: pg_restore: warning: invalid creation date in header
Date
Msg-id 52961.1623600745@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore: warning: invalid creation date in header  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: pg_restore: warning: invalid creation date in header
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: pg_restore & locks
Next
From: Wells Oliver
Date:
Subject: Re: pg_restore: warning: invalid creation date in header