Re: pg_upgrade with link option - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_upgrade with link option
Date
Msg-id 201103111233.p2BCXqJ17562@momjian.us
Whole thread Raw
In response to Re: pg_upgrade with link option  (Robert Treat <rob@xzilla.net>)
List pgsql-admin
Robert Treat wrote:
> On Thu, Mar 10, 2011 at 1:30 PM, Bruce Momjian <bruce@momjian.us> 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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: pg_upgrade with link option
Next
From: Bruce Momjian
Date:
Subject: Re: Listen on IPv6 only