BUG #1301: pg_restore failed on AMD 64bit machine - Mailing list pgsql-bugs

From PostgreSQL Bugs List
Subject BUG #1301: pg_restore failed on AMD 64bit machine
Date
Msg-id 20041029150839.CC6CF5A11FD@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1301: pg_restore failed on AMD 64bit machine  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1301
Logged by:          hongyi

Email address:      hongyi_gao@hotmail.com

PostgreSQL version: 7.4.5

Operating system:   SuSe 9.1

Description:        pg_restore failed on AMD 64bit machine

Details:


pg_restore has flow on AMD64 machine.

When I try restore a backup (made by pg_dump with -Fc option), when it
reaches some specific table/at some specific positions in the backup file,
it will fail. This only happened on 64bit machines with version 7.4.0-7.4.6

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

For a specific backup, it'll always fail at the same place.

But, if I copy the backup data to other 32bit machines, and run pg_restore
with -h remotely restore the data, everything is fine. It's succesfully
finished.

Tried version 7.4.6, still failed.
Tried compile source and install, same.

a bug in pg_restore.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.0 Beta 4 - Qualified ORDER BY column name not working on UNION query
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1298: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"