Skip site navigation (1) Skip section navigation (2)

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

From: "Satheesan K Nair" <support(at)shakthiinnovators(dot)com>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>,"Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: pg_restore: [custom archiver] error during file seek: Invalid argument
Date: 2011-11-02 04:36:12
Message-ID: 003301cc9918$f77f9460$dc01a8c0@shakthi2f0f1ab (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Magnus & Heiki,

The above problem solved when I have connected 8.1 server through PgAdmin 
III OF 9.1 version and restored.

So, I think there was some bug fix related to the above problem in PgSql 9.1 
pg_restore.exe.

This is for your reference and information.

Thanks and regards,
Satheesan K Nair
India

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


On Mon, Oct 31, 2011 at 12:03, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> On 31.10.2011 12:12, Satheesan K Nair wrote:
>>
>> Our Operating System is Windows XP.
>>
>> Should we need to do any changes in any kind of configurations in
>> Windows XP or PostgreSql??
>
> According to the commit logs, there was a win32-related fix to this on 
> 8.2,
> and some further MinGW-related changes in 8.4.
>
> Regardless of this issue, I'd suggest that you upgrade to the latest
> version, 9.1.1. 8.1 isn't supported anymore, and 8.2 is just about to 
> reach
> EOL by the end of December
> (http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy).

Note that 8.1 was EOL'ed on Windows specifically even earlier than it
was in general.


>> 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??
>
> I believe the dump is OK, but restoring it doesn't work on version 8.1 on
> Windows.

A workaround could be to run pg_restore on a 64-bit Unix box, talking
to postgresql server on Windows. That should work around the issue -
since the bug is in pg_dump/pg_restore and not in the backend.

But I second and thid Heikkis recommendation that you need to get off
version 8.1 and onto something more recent as quickly as possible.

-- 
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/ 


In response to

pgsql-bugs by date

Next:From: Naoya AnzaiDate: 2011-11-02 04:44:23
Subject: BUG #6283: About the behavior of indexscan in case there are some NULL values.
Previous:From: Finlay ThompsonDate: 2011-11-02 03:54:53
Subject: Re: BUG #6275: Horrible performance regression

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group