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 .
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 |