Re: pg_restore [archiver] file offset in dump file is too - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_restore [archiver] file offset in dump file is too
Date
Msg-id 43683ED3.8020103@dunslane.net
Whole thread Raw
In response to pg_restore [archiver] file offset in dump file is too large  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: pg_restore [archiver] file offset in dump file is too  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hmm. Windows reports an offset size of 4 bytes on a dump I just made ... 
is that relevant? What governs it?

cheers

andrew

Kevin Grittner wrote:

>Posting here because it may be a 8.1 pre-release problem.  I'll take
>it to the admin list if it looks like it's not.
>
>File dumped from 8.1beta3 using pg_dump -Fc on Linux box.
>This dump restored successfully onto 8.1RC1 on Linux box.
>File FTP'd to Windows box; attempt to restore onto 8.1RC1 fails with:
>
>pg_restore [archiver] file offset in dump file is too large
>
>This happens even wilth pg_restore -l <filename>
>
>All instanced init'd with --locale=C
>
>Both Linux and Windows 8.1RC1 instances give:
>
>dtr=> \l
>        List of databases
>   Name    |  Owner   | Encoding
>-----------+----------+-----------
> dtr       | dtr      | SQL_ASCII
> postgres  | postgres | SQL_ASCII
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
>(4 rows)
>
>(Source database was also SQL_ASCII.)
>
>On the Linux box:
>
>; Archive created at Mon Oct 31 20:00:01 2005
>;     dbname: dtr
>;     TOC Entries: 166
>;     Compression: -1
>;     Dump Version: 1.10-0
>;     Format: CUSTOM
>;     Integer: 4 bytes
>;     Offset: 8 bytes
>;     Dumped from database version: 8.1beta3
>;     Dumped by pg_dump version: 8.1beta3
>
>-rw-r--r--  1 postgres users 40874747876 Nov  1 05:27 dtr.dump
>
>On Windows, the file size and md5sum -b result is identical.
>
>Any suggestions on things to check or try?
>
>-Kevin
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>  
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore [archiver] file offset in dump file is too large
Next
From: Tom Lane
Date:
Subject: Re: 8.1-compatible xlogdump