Re: pg_restore and large files

Mike Charnoky <noky@nextbus.com> writes:
> I am currently using PostgreSQL v7.3.4 on a RedHat 8.0 system (2.4.23 kernel)
> using the ext3 filesystem.  I am experiencing problems when performing a
> pg_restore using a file which is 2.3G in size.  The dump, which seemed to run
> smoothly, was created using the -Fc option.  When I perform the restore, the
> following error occurs before the pg_restore fails:

> pg_restore: [custom archiver] error during file seek: Invalid argument
> pg_restore: *** aborted because of error

> Why is this happening?  The error comes from pg_backup_custom.c, it seems that
> an fseeko() is failing (even though this is the way to support large
> files).

Hm, can you insert some debugging printout to show the offset value
being passed to fseeko?  That would let us eliminate one of pg_restore
and the kernel as being at fault.  Another thing that'd be useful is to
run pg_restore under gdb with a breakpoint set at die_horribly, so that
you could get a stack trace from the point of the failure.

I am suspicious that it's a pg_restore bug and the problem has to do
with manipulating file offsets as plain integers someplace.  Not enough
info yet to go searching, though.

            regards, tom lane