Re: pg_restore: [custom archiver] error during file seek: Invalid argument

Hi Heiki,

Our Operating System is Windows XP.

Should we need to do any changes in any kind of configurations in Windows XP
or PostgreSql??

We are trying to restore the data base backup in 8.1 version through 9.1
PGAdmin III.

PGDump ran through "Fedora Linux 10 (Data Base Server) OS".

Is there any other chance to give the above error? I meant something like,
1.pgdump not completed the dumping properly,
2.the Backup file is not saved/copied properly, etc??

Satheesan K Nair
India

----- Original Message -----
From: "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "Satheesan K Nair" <support(at)shakthiinnovators(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Monday, October 31, 2011 3:25 PM
Subject: Re: [BUGS] pg_restore: [custom archiver] error during file seek:
Invalid argument

> On 31.10.2011 07:55, Satheesan K Nair wrote:
>> We are trying to restore a 3.2GB sized POstgreSql 8.1 Data base. When it
>> is reaching a particular table restoration, giving error as "pg_restore:
>> [custom archiver] error during file seek: Invalid argument" and exiting
>> the restoration.
>>
>> Then when we have googled it, we found that PostgreSql will not support a
>> Backup file of more than 2 GB. We would like to know that any of later
>> Versions of the PostgreSql have been got fixed this problem?
>
> I belive PostgreSQL has been able to handle that since version 7.3, if the
> operating system support is there. What operating system and version do
> you use?
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com