pg_upgrade failure upgrading from v10.8 to v14.4

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_upgrade failure upgrading from v10.8 to v14.4
Date: 2022-07-22 16:19:42
Message-ID: DM8PR09MB667740FCD23BCFECA20E8A3CB8909@DM8PR09MB6677.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Folks,

I am testing upgrade of my cluster from version 10.8 to 14.4

I encountered following error. Any help or insight is much appreciated.

Thanks.

*failure*
Consult the last few lines of "pg_upgrade_dump_16400.log" for
the probable cause of the failure.

Last few lines of pg_upgrade_dump_16400.log:

pg_restore: error: could not execute query: ERROR: column c.relhaspkey does not exist
LINE 19: "c"."relhaspkey" AS "haspkey",
^
Command was:
-- For binary upgrade, must preserve pg_type oid
SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('16681'::pg_catalog.oid);

-- For binary upgrade, must preserve pg_type array oid
SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('16680'::pg_catalog.oid);

-- For binary upgrade, must preserve pg_class oids
SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('16679'::pg_catalog.oid);

CREATE VIEW "public"."all_tables" AS
SELECT ((("n"."nspname")::"text" || '.'::"text") || ("c"."relname")::"text") AS "tablename",

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-07-22 16:30:32 Re: pg_upgrade failure upgrading from v10.8 to v14.4
Previous Message Raj kumar 2022-07-22 09:11:25 Query to check Progress of Alter Statements PostgreSQL