PG_UPGRADE FAILED FROM 9.5 to 11*

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

Responses

Browse pgsql-bugs by date

  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