Upgrading from Postgres 9.3 to 9.5

From: "Kevin Struckhoff" <kevins(at)thermal(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Upgrading from Postgres 9.3 to 9.5
Date: 2016-04-11 17:28:28
Message-ID: DM2PR0101MB0781F0F423A453F0A915EB7BD2940@DM2PR0101MB0781.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

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.

Thanks
Kevin Struckhoff

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Keith 2016-04-11 18:06:03 Re: Upgrading from Postgres 9.3 to 9.5
Previous Message Albe Laurenz 2016-04-11 15:32:50 Re: One tablespace or several tablespaces