Re: pg_restore: [custom archiver] error during file seek: Invalid argument - Mailing list pgsql-bugs

From Satheesan K Nair
Subject Re: pg_restore: [custom archiver] error during file seek: Invalid argument
Date
Msg-id 004001cc97b5$aff11970$dc01a8c0@shakthi2f0f1ab
Whole thread Raw
In response to pg_restore: [custom archiver] error during file seek: Invalid argument  ("Satheesan K Nair" <support@shakthiinnovators.com>)
List pgsql-bugs
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.linnakangas@enterprisedb.com>
To: "Satheesan K Nair" <support@shakthiinnovators.com>
Cc: <pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "Satheesan K Nair"
Date:
Subject: Re: pg_restore: [custom archiver] error during file seek: Invalid argument
Next
From: Tom Lane
Date:
Subject: Re: BUG #6278: Index scans on '>' condition on field with many NULLS