BUG #14226: pg_upgrade for 8.4 to 9.4 failed

From: nqtien310(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14226: pg_upgrade for 8.4 to 9.4 failed
Date: 2016-07-04 13:43:38
Message-ID: 20160704134338.1397.58009@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14226
Logged by: Tien Nguyen
Email address: nqtien310(at)gmail(dot)com
PostgreSQL version: 9.4.0
Operating system: GNU/Linux
Description:

I did the cluster compatible check with "/usr/pgsql-9.4/bin/pg_upgrade -c -d
/var/lib/pgsql/data -D /var/lib/pgsql/9.4.test/data -b /usr/bin/ -B
/usr/pgsql-9.4/bin/", and it says "*Clusters are compatible*",

But then the process was failed when I run the actual upgrade
"/usr/pgsql-9.4/bin/pg_upgrade -d /var/lib/pgsql/data -D
/var/lib/pgsql/9.4.test/data -b /usr/bin/ -B /usr/pgsql-9.4/bin/

I consulted the log and saw these errors:
------------------
pg_restore: creating CONSTRAINT yodlee_user_accounts_pkey
pg_restore: creating INDEX concurrently
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2638; 1259 19738 INDEX
concurrently blueleaf
pg_restore: [archiver (db)] could not execute query: ERROR: CREATE INDEX
CONCURRENTLY cannot be executed from a function or multi-command string
Command was:
-- For binary upgrade, must preserve pg_class oids
SELECT
binary_upgrade.set_next_index_pg_class_oid('19738'::pg_catalog.oi...
------------------

I have no clue what these errors are about, please help .

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message rob.nieuwenhuizen 2016-07-04 13:44:38 BUG #14227: Former master not shot down
Previous Message Heikki Rauhala 2016-07-04 12:10:32 "insert [...] on conflict" hangs on conflict on an unmentioned gist index