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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org