Yes, the tar file contains a file called 1765.dat. A `cat` of that
file shows nothing more than an empty line (i.e.: a carriage return).
-rw------- 1 frankel prod 1 Nov 29 11:20 1765.dat
Extracting the archive, tar reported a "lone zero block." I don't
know what this refers to.
tar: A lone zero block at 9242
I'm happy to either help debug Ft or switch to Fc in my scripts. I
was under the impression, though, that Ft was required to backup db's
with blobs. I am storing some thumbnail jpg images in my db.
I'd also be interested to know if the pg_restore error is due to my
upgrade to postgres 8.1 or macosx 10.4.3.
Thanks
Scott
On Dec 1, 2005, at 4:47 PM, Tom Lane wrote:
Scott Frankel <[EMAIL PROTECTED]> writes:
What does this error mean?
pg_restore: [tar archiver] could not find header for file 1765.dat
in tar archive
It means either the tar file is corrupt or pg_restore has a bug.
Can tar read the file correctly? If so, does it find a file named
1765.dat therein?
(Historically, the tar code in pg_dump/pg_restore has not been as
well debugged as the custom format, so you might want to just use
-Fc instead. If you're really intent on using -Ft, be prepared to
help us debug it.)
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
