Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EFAAF632C31 for ; Fri, 11 Jun 2010 11:01:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 02644-02 for ; Fri, 11 Jun 2010 14:01:32 +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 B1FCC632712 for ; Fri, 11 Jun 2010 11:01:33 -0300 (ADT) Received: by gye5 with SMTP id 5so674025gye.19 for ; Fri, 11 Jun 2010 07:01:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:cc:content-type; bh=MYtBYSN6JwkV4OIQGXiS+oRy4ss6H2CIkJJE0uBQf4U=; b=rKz+NPX6H5ld8MiRy6cvYK2IE6sbvZnQrI2HPgokwa+4qdOLdF/pqnkxF9Ibjrs+pe FEAKFcGxoYlT1XPOayyEeN8RVUslB8YumVM2itEvzAJEMusJXpu+1AgXZdtOQMFy/KY3 EwT8Tz+W8SgEphi2XAMVcblqxyWRVE1FZM4LM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=kW1lvEGmCPXcEbE+lOTX4EyDdPVkP8bIFVyq1beJRu/WDL9NgAzfPx6Lot0RJJZ+Ts 1na536t1bk5aFsXUtS6Vz8UxxIRV52l9Cnd6tPmeJy+1kijgnxNoDVIunKQcT4TQwlJL 1uray0JIuSZMNRyTa1E7UjQcFdlhrU7TKN51I= Received: by 10.216.85.71 with SMTP id t49mr1997434wee.19.1276264891182; Fri, 11 Jun 2010 07:01:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.188.209 with HTTP; Fri, 11 Jun 2010 07:01:11 -0700 (PDT) In-Reply-To: References: From: Thom Brown Date: Fri, 11 Jun 2010 15:01:11 +0100 Message-ID: Subject: Re: pg_upgrade invalid option To: Dave Page Cc: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-5 required=5 tests=BAYES_05=-0.5 X-Spam-Level: X-Archive-Number: 201006/17 X-Sequence-Number: 5585 On 11 June 2010 14:55, Dave Page wrote: > On Fri, Jun 11, 2010 at 2:50 PM, Thom Brown wrote: >> I've tried following the instructions on this page: >> http://www.postgresql.org/files/documentation/books/aw_pgsql/node267.html >> >> This mentions a -f option but my version of pg_upgrade doesn't appear >> to support this: >> >> /usr/lib64/postgresql-9.0/bin/pg_upgrade: invalid option -- 'f' >> >> The only options available are: >> > > >> Are those instructions for an older version? >> > > That's Bruce's book which is probably 8 or 9 years old now. It's > almost certainly referring to the old pg_upgrade shell script from > years ago. > Ah, unfortunately that's the first result in Google. I've resorted to restoring from a full backup :( I don't think I could use it for upgrading from beta 1 to beta 2 anyway by the looks of things. The binary directories are updated since they share the same version number. Thom