pg_restore and large files - Mailing list pgsql-general

From Mike Charnoky
Subject pg_restore and large files
Date
Msg-id 402251DB.4010305@nextbus.com
Whole thread Raw
Responses Re: pg_restore and large files
List pgsql-general
Hello,

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).  It
is my understanding that ext3 supports file sizes up to 1T.  The restore worked
fine when the database was smaller.  Any ideas?

Thanks,

Mike Charnoky


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: size of mailing lists?
Next
From: Mark Gibson
Date:
Subject: dblink - custom datatypes don't work