Re: pg_upgrade with link option

From: Robert Treat <rob(at)xzilla(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
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:30:20
Message-ID: AANLkTinVBHf8Krfmnk9xUUg9xFn6vf1ugDVmAVwGU_Uf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

>
> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2011-03-11 12:33:52 Re: pg_upgrade with link option
Previous Message Gnanakumar 2011-03-11 10:20:28 PSQLException: ERROR: could not open relation with OID xxxx