Cannot upgrade from 9.3 to 9.4 using pg_upgrade

From: Arthur Pemberton <pembo13(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cannot upgrade from 9.3 to 9.4 using pg_upgrade
Date: 2016-01-03 08:02:21
Message-ID: CA+X4dQQ2dv6wVYQ7GCixbbGSwOaFz1HsV5AcLVcfS8MbTeYVyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with
packages from Postgres' yum repo.

I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't
get very far however, I get the following error, and Google doesn't seem to
help.

-bash-4.1$ /usr/pgsql-9.4/bin/pg_upgrade --jobs 4 \
> --old-datadir "/var/lib/pgsql/9.3/data" \
> --new-datadir "/var/lib/pgsql/9.4/data" \
> --old-bindir "/usr/pgsql-9.3/bin" \
> --new-bindir "/usr/pgsql-9.4/bin"
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
SQL command failed
CREATE TEMPORARY TABLE info_rels (reloid) AS SELECT c.oid FROM
pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON
c.relnamespace = n.oid LEFT OUTER JOIN pg_catalog.pg_index i ON
c.oid = i.indexrelid WHERE relkind IN ('r', 'm', 'i', 'S') AND
i.indisvalid IS DISTINCT FROM false AND i.indisready IS DISTINCT FROM
false AND ((n.nspname !~ '^pg_temp_' AND n.nspname !~
'^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog',
'information_schema', 'binary_upgrade', 'pg_toast') AND
c.oid >= 16384) OR (n.nspname = 'pg_catalog' AND relname IN
('pg_largeobject', 'pg_largeobject_loid_pn_index',
'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index') ));
ERROR: relation "info_rels" already exists

Failure, exiting

Please advise,
Arthur Pemberton

Browse pgsql-general by date

  From Date Subject
Next Message Arthur Pemberton 2016-01-03 08:03:43 Cannot upgrade from 9.3 to 9.4 using pg_upgrade
Previous Message Brar Piening 2016-01-02 20:05:08 Re: How do I implement a .XSD in Postgres?