pg_restore and large files

Поиск
Список
Период
Сортировка
От Mike Charnoky
Тема pg_restore and large files
Дата
Msg-id 402251DB.4010305@nextbus.com
обсуждение исходный текст
Ответы Re: pg_restore and large files
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: size of mailing lists?
Следующее
От: Mark Gibson
Дата:
Сообщение: dblink - custom datatypes don't work