From: | Jaspreet Singh <jaspresingh(at)tesla(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | PG_UPGRADE FAILED FROM 9.5 to 11* |
Date: | 2020-06-18 18:42:11 |
Message-ID: | BYAPR16MB2789E8E00904B6ED17FE1955BE9B0@BYAPR16MB2789.namprd16.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Team
We are upgrading our 9.5 postgres database to 11* version and it failed with below error . please help .
/usr/pgsql-11/bin/pg_upgrade -b /usr/pgsql-9.5/bin -B /usr/pgsql-11/bin -d /pgdata/data -D /var/lib/pgsql/11/data/
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 185; 1259 1183792 VIEW pg_stat_activity postgres
pg_restore: [archiver (db)] could not execute query: ERROR: column pg_stat_activity.waiting does not exist
LINE 27: "pg_stat_activity"."waiting",
^
Command was:
-- For binary upgrade, must preserve pg_type oid
SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('1183794'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_type array oid
SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('1183793'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_class oids
SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('1183792'::pg_catalog.oid);
Thanks & Regards
Jaspreet Singh
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2020-06-18 19:24:08 | BUG #16502: EXPLAIN JSON format adds extra quotes around index names |
Previous Message | Bruce Momjian | 2020-06-18 18:29:43 | Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match |