Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3338E1337B61 for ; Fri, 11 Mar 2011 08:33:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 05805-09 for ; Fri, 11 Mar 2011 12:33:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 8E43F133616B for ; Fri, 11 Mar 2011 08:33:48 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p2BCXqJ17562; Fri, 11 Mar 2011 07:33:52 -0500 (EST) From: Bruce Momjian Message-Id: <201103111233.p2BCXqJ17562@momjian.us> Subject: Re: pg_upgrade with link option In-Reply-To: To: Robert Treat Date: Fri, 11 Mar 2011 07:33:52 -0500 (EST) CC: Mark Johnson , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/144 X-Sequence-Number: 37016 Robert Treat wrote: > On Thu, Mar 10, 2011 at 1:30 PM, Bruce Momjian wrote: > > Mark Johnson wrote: > >> export PGPORT1=5432 > >> export PGPORT2=5432 > >> export PGDATA1=/pgdata1/test > >> export PGDATA2=/pgdata1/test > >> export PGBIN1=/pghome/9.0.2/bin > >> export PGBIN2=/pghome/9.0.3/bin > > ISTM you need to change the pgdata and pgport for the second cluster, > as they will both need to run simultaneously during the upgrade > process. Oh, yikes. I know you can share tablespaces between old and new servers, except for an upgrade of the same major version, which is what we are doing here. You can never share data directories. --------------------------------------------------------------------------- > > > > > You have shown a lot of text above, but not the error message you got. > > Can I see that please? > > > > Agree with Bruce, showing us any error messages would be helpful. > > > Robert Treat > play: xzilla.net > work: omniti.com > hiring: l42.org/lg -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +