Failed upgrade from 12.11 to 14.4

From: Arthur Ramsey <arthur(dot)ramsey(at)code42(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Failed upgrade from 12.11 to 14.4
Date: 2023-03-01 16:32:23
Message-ID: CAEJqy4WSLUO+j86e9T9rKXLqg=RoNzzS==my0Ymzsa0nYo-s2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Database instance is in a state that cannot be upgraded: pg_restore: from
TOC entry 1264; 1259 32392758 VIEW pg_stat_activity_allusers master
pg_restore: error: could not execute query: ERROR: column reference "query"
is ambiguous LINE 32: "get_sa"."query" ^ Command was: -- For binary
upgrade, must preserve pg_type oid SELECT
pg_catalog.binary_upgrade_set_next_pg_type_oid('32392760'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_type array oid SELECT
pg_catalog.binary_upgrade_set_next_array_pg_type_oid('32392759'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_class oids SELECT
pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('32392758'::pg_catalog.oid);
CREATE VIEW
"publiczugmgeaxkmwph5jgobvwmvzb9freg0s7"."pg_stat_activity_allusers" AS
SELECT "get_sa"."datid", "get_sa"."datname", "get_sa"."pid",
"get_sa"."usesysid", "get_sa"."usename", "get_sa"."application_name",
"get_sa"."client_addr", "get_sa"."client_hostname", "get_sa"."client_port",
"get_sa"."backend_start", "get_sa"."xact_start", "get_sa"."query_start",
"get_sa"."state_change", "get_sa"."wait_event_type", "get_sa"."wait_event",
"get_sa"."state", "get_sa"."backend_xid", "get_sa"."backend_xmin",
"get_sa"."query" FROM "publiczugmgeaxkmwph5jgobvwmvzb9freg0s7"."get_sa"()
"get_sa"("datid", "datname", "pid", "usesysid", "usename",
"application_name", "client_addr", "client_hostname", "client_port",
"backend_start", "xact_start", "query_start", "state_change",
"wait_event_type", "wait_event", "state", "backend_xid", "backend_xmin",
"query", "backend_type");".

Thanks,
Arthur

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-03-01 19:54:30 Re: Failed upgrade from 12.11 to 14.4
Previous Message Thomas Munro 2023-03-01 01:29:20 Re: Interval in hours but not in days Leap second not taken into account