nqtien310@gmail.com writes:
> 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:
Drop or rename your index named "concurrently".
(PG 9.0 and up seem to quote that index name safely, but 8.4 doesn't,
and it's long out of support.)
regards, tom lane