X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 56FF5DA946 for ; Thu, 22 Sep 2005 13:00:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08501-09 for ; Thu, 22 Sep 2005 16:00:45 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id B63E6DA959 for ; Thu, 22 Sep 2005 13:00:44 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8MG0Rrg013574 for ; Thu, 22 Sep 2005 16:00:44 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8MFw0EF011328 for pgsql-admin@postgresql.org; Thu, 22 Sep 2005 15:58:00 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: pg_restore fails Date: Thu, 22 Sep 2005 17:57:54 +0200 Organization: Hub.Org Networking Services Lines: 10 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.485 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.335] X-Spam-Level: X-Archive-Number: 200509/234 X-Sequence-Number: 18971 On 16.09.2005 07:31, Victor Sudakov wrote: > Is there any way to fix or workaround this except editing the dump with a text editor (very frustrating with dozens of objects in several schemas being out of order)? In case you only have a text dump.. uhm.. No. In case it's a binary dump, using a newer version of pg_restore (8.0 oder 8.1 for example) with -i option should fix it to my understanding. Best regards, Hannes Dorbath