From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_restore [archiver] file offset in dump file is too |
Date: | 2005-11-02 04:21:39 |
Message-ID: | 43683ED3.8020103@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-02 04:24:13 | Re: 8.1-compatible xlogdump |
Previous Message | Tom Lane | 2005-11-02 04:15:49 | Re: pg_restore [archiver] file offset in dump file is too large |