Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7553562F118 for ; Sat, 17 Apr 2010 14:48:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 75581-09 for ; Sat, 17 Apr 2010 17:48:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from polaris.pinpointresearch.com (cerberus.pinpointresearch.com [66.7.238.130]) by mail.postgresql.org (Postfix) with ESMTP id 83A206322C2 for ; Sat, 17 Apr 2010 14:48:24 -0300 (ADT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 58362E00EC84; Sat, 17 Apr 2010 10:48:20 -0700 (PDT) Message-ID: <4BC9F464.20901@pinpointresearch.com> Date: Sat, 17 Apr 2010 10:48:20 -0700 From: Steve Crawford User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Bryan White CC: pgsql-admin@postgresql.org Subject: Re: pg_restore error References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.747 tagged_above=-10 required=5 tests=AWL=0.163, BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/239 X-Sequence-Number: 34333 Bryan White wrote: > I am trying to load a data base using pg_restore...... Is there a known problem with using parallel > loading in 8.4 from a file created with an 8.1 database? > It was unclear from your email how you are creating the dump. Did you create the dump with the 8.1 or the 8.4 version of pg_dump? When upgrading, the docs recommend using the newer version of the dump utility: "It is recommended that you use the pg_dump and pg_dumpall programs from the newer version of PostgreSQL, to take advantage of any enhancements that might have been made in these programs. Current releases of the dump programs can read data from any server version back to 7.0." How many cores are available on the new server? Cheers, Steve