Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D0E27634EF0 for ; Tue, 20 Apr 2010 13:28:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97884-03-3 for ; Tue, 20 Apr 2010 16:28:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 79E8463683B for ; Tue, 20 Apr 2010 13:05:27 -0300 (ADT) Received: by gyg13 with SMTP id 13so3271140gyg.19 for ; Tue, 20 Apr 2010 09:05:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type; bh=b8b978wiTCuvXc1kubwjIpAkHB/g0S0UPiYok6oZdxY=; b=n+pDZXF/XWduwRqCqApVI+P23HUtJkunpkCISbypdq7E+rbHM7/8yoBGiRH/ogf7lc /fZheqWzkFkaDAPFNElaiz4d9VvOm0FiDumFQbjZAlynvffAkp/olipd7DFRJMteHmmA dCdwyZ0k78VHWeSGYzAmOAYet7sJD6eoNGMbU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=W8tCdqctb9q5k0kxpzhJErftfgGEnKhiApTlMsfcBte/xUWQ4az45pnRhpLewvxxiy 7k98wFmh9KaI0+lEaargngMAc8ZB6fofNPz4PW53lHO6Q79EXjMnYT7/8kI4sI2EQh4w KQ24RxRt3fPqoJUHUFJPa4ixXqnPZcr+zz6nk= MIME-Version: 1.0 Received: by 10.150.218.9 with HTTP; Tue, 20 Apr 2010 09:05:26 -0700 (PDT) In-Reply-To: References: Date: Tue, 20 Apr 2010 10:05:26 -0600 Received: by 10.151.59.11 with SMTP id m11mr2127931ybk.342.1271779527006; Tue, 20 Apr 2010 09:05:27 -0700 (PDT) Message-ID: Subject: Re: pg_restore -j From: Scott Marlowe To: Justin Falk Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201004/288 X-Sequence-Number: 34382 On Wed, Apr 14, 2010 at 12:38 AM, Justin Falk wrote: > Hi, > > I'm trying to use the -j option on pg_restore while restoring a database > into PG 8.4.3. > > The dump was executed on PG 8.3.7 (Windows, Server 2003) using: I think you have to dump with 8.4 to use -j on restore.