Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E47FE9FB1CE for ; Tue, 28 Nov 2006 20:05:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 29292-08 for ; Tue, 28 Nov 2006 20:05:20 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 61B6B9FB20F for ; Tue, 28 Nov 2006 20:05:24 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id kAT05Nls076941 for ; Tue, 28 Nov 2006 20:05:23 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id kASNVQrf067214 for pgsql-admin@postgresql.org; Tue, 28 Nov 2006 19:31:26 -0400 (AST) (envelope-from news) From: Peter Wilson X-Newsgroups: pgsql.admin Subject: Re: Problem restoring with pg_dump Date: Tue, 28 Nov 2006 23:31:24 +0000 Organization: Hub.Org Networking Services Lines: 100 Message-ID: References: <6113.1164728816@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) In-Reply-To: <6113.1164728816@sss.pgh.pa.us> X-Enigmail-Version: 0.94.0.0 X-Antivirus: avast! (VPS 0651-2, 28/11/2006), Outbound message X-Antivirus-Status: Clean To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/233 X-Sequence-Number: 23760 Tom Lane wrote: > Peter Wilson writes: >> pg_restore : [custom archiver] Dumping a specific TOC data block out of order is >> not supported without ID on this input stream (fseek required). > > Could you show us the unmodified output from pg_restore -l, as well as > the edits you made to produce the -L script? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > Raw output from pg_restore -l is as follows: ================================= ; ; Archive created at Mon Nov 27 01:35:56 2006 ; dbname: whitebeam ; TOC Entries: 24 ; Compression: 9 ; Dump Version: 1.10-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.1.4 ; Dumped by pg_dump version: 8.1.4 ; ; ; Selected TOC Entries: ; 1656; 0 0 SEQUENCE SET public audit_id_seq whitebeam 1657; 0 0 SEQUENCE SET public collection_id_seq whitebeam 1658; 0 0 SEQUENCE SET public contacts_contact_id_seq whitebeam 1659; 0 0 SEQUENCE SET public files_file_id_seq whitebeam 1660; 0 0 SEQUENCE SET public items_item_id_seq whitebeam 1661; 0 0 SEQUENCE SET public searchtree_node_id_seq whitebeam 1654; 0 89555 TABLE DATA public audit whitebeam 1652; 0 43231 TABLE DATA public collection_types whitebeam 1653; 0 43243 TABLE DATA public collections whitebeam 1639; 0 43140 TABLE DATA public contact_att whitebeam 1649; 0 43203 TABLE DATA public contact_item whitebeam 1650; 0 43208 TABLE DATA public contact_node whitebeam 1638; 0 43131 TABLE DATA public contacts whitebeam 1646; 0 43185 TABLE DATA public files whitebeam 1643; 0 43165 TABLE DATA public item_files whitebeam 1641; 0 43154 TABLE DATA public item_leafs whitebeam 1647; 0 43194 TABLE DATA public item_prices whitebeam 1644; 0 43169 TABLE DATA public itemdata whitebeam 1645; 0 43178 TABLE DATA public items whitebeam 1648; 0 43199 TABLE DATA public node_leafs whitebeam 1640; 0 43146 TABLE DATA public searchtree whitebeam 1651; 0 43213 TABLE DATA public site whitebeam 1642; 0 43158 TABLE DATA public stockdata whitebeam ================================= The re-ordered version is: ================================= ; ; Archive created at Mon Nov 27 01:35:56 2006 ; dbname: whitebeam ; TOC Entries: 24 ; Compression: 9 ; Dump Version: 1.10-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.1.4 ; Dumped by pg_dump version: 8.1.4 ; ; ; Selected TOC Entries: ; 1656; 0 0 SEQUENCE SET public audit_id_seq whitebeam 1657; 0 0 SEQUENCE SET public collection_id_seq whitebeam 1658; 0 0 SEQUENCE SET public contacts_contact_id_seq whitebeam 1659; 0 0 SEQUENCE SET public files_file_id_seq whitebeam 1660; 0 0 SEQUENCE SET public items_item_id_seq whitebeam 1661; 0 0 SEQUENCE SET public searchtree_node_id_seq whitebeam 1638; 0 43131 TABLE DATA public contacts whitebeam 1645; 0 43178 TABLE DATA public items whitebeam 1639; 0 43140 TABLE DATA public contact_att whitebeam 1649; 0 43203 TABLE DATA public contact_item whitebeam 1650; 0 43208 TABLE DATA public contact_node whitebeam 1646; 0 43185 TABLE DATA public files whitebeam 1643; 0 43165 TABLE DATA public item_files whitebeam 1647; 0 43194 TABLE DATA public item_prices whitebeam 1644; 0 43169 TABLE DATA public itemdata whitebeam 1640; 0 43146 TABLE DATA public searchtree whitebeam 1648; 0 43199 TABLE DATA public node_leafs whitebeam 1641; 0 43154 TABLE DATA public item_leafs whitebeam 1642; 0 43158 TABLE DATA public stockdata whitebeam 1652; 0 43231 TABLE DATA public collection_types whitebeam 1653; 0 43243 TABLE DATA public collections whitebeam 1654; 0 89555 TABLE DATA public audit whitebeam 1651; 0 43213 TABLE DATA public site whitebeam ================================= Pete