Re: pg_restore error

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 <leknarf(at)pacbell(dot)net> 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