From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Kevin Struckhoff <kevins(at)thermal(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Upgrading from Postgres 9.3 to 9.5 |
Date: | 2016-04-11 18:22:53 |
Message-ID: | CAKFQuwZFKdRFmYpLb6fJ_Dt3vAKHr1Va3TZaoFQJ+CPsXTc4_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Apr 11, 2016 at 10:28 AM, Kevin Struckhoff <kevins(at)thermal(dot)com>
wrote:
> Hi,
>
>
>
> I’m attempting my first upgrade of Postgres from 9.3 to 9.5. I’ve run into
> two roadblocks but not sure how to get around them. I have my 9.3 PGDATA
> set to /data/postgres, which is a separate filesystem on my RHEL 6 server.
> After installing 9.5 and running initdb, I attempted to run pg_upgrade
> using this command line:
>
>
>
> /usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.3/bin -B /usr/pgsql-9.5/bin
> -d /data/postgres -D /var/lib/pgsql/9.5/data --link -p 5432 -P 5433 -c
>
>
>
> This command failed the link parameter test, because the 9.5 PGDATA value
> is not on the same filesystem as 9.3. Roadblock #1.
>
>
>
Ok, so don't use "hard" links then.
> I then tried to re-initialize 9.5 using this command: initdb -D
> /data/postgres95. It errored saying ‘Data directory is not empty!’.
> Roadblock #2.
>
>
>
> How do I proceed with this upgrade? I’d rather not move to a new server.
>
>
>
Gonna need to wait for someone else here as I haven't used pg_upgrade.
Suggest playing with test databases and not using "--link" while you wait.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Struckhoff | 2016-04-11 18:24:10 | Re: Upgrading from Postgres 9.3 to 9.5 |
Previous Message | Keith | 2016-04-11 18:06:03 | Re: Upgrading from Postgres 9.3 to 9.5 |