Обсуждение: BUG #1301: pg_restore failed on AMD 64bit machine

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.

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> 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

How big is the backup file?  I'm wondering if this could be a
32-bit-file-offset issue.

In general it would be nice to have more details, like *which* specific
positions ...

            regards, tom lane