Re: pg_upgrade with link option

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Robert Treat <rob(at)xzilla(dot)net>
Cc: Mark Johnson <mark(at)remingtondatabasesolutions(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_upgrade with link option
Date: 2011-03-11 12:33:52
Message-ID: 201103111233.p2BCXqJ17562@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robert Treat wrote:
> On Thu, Mar 10, 2011 at 1:30 PM, Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2011-03-11 15:31:51 Re: Listen on IPv6 only
Previous Message Robert Treat 2011-03-11 12:30:20 Re: pg_upgrade with link option