From: Bruce Momjian <bruce@momjian.us>
To: Robert Treat <rob@xzilla.net>
Cc: Mark Johnson <mark@remingtondatabasesolutions.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade with link option
Date: Fri, 11 Mar 2011 07:33:52 -0500 (EST)
Message-ID: <201103111233.p2BCXqJ17562@momjian.us> (raw)
In-Reply-To: <AANLkTinVBHf8Krfmnk9xUUg9xFn6vf1ugDVmAVwGU_Uf@mail.gmail.com>
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. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, rob@xzilla.net, mark@remingtondatabasesolutions.com
Subject: Re: pg_upgrade with link option
In-Reply-To: <201103111233.p2BCXqJ17562@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox