Hi,
When trying to upgrade from PostgreSQL 10 to 12, the installation fails as shown below.
# pg_upgradecluster --link --method=upgrade 10 main /dbdata/zabbix
From PosgreSQL log:
2021-05-04 13:06:04.780 CEST [12861] LOG: database system is ready to accept connections
done
server started
.
.
2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db ERROR: column r.relhasoids does not exist at character 1616
2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db STATEMENT:
-- For binary upgrade, must preserve pg_type oid
SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('162222'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_type array oid
SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('162221'::pg_catalog.oid);
-- For binary upgrade, must preserve pg_class oids
SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('162220'::pg_catalog.oid);
CREATE VIEW "repack"."tables" AS
SELECT ("r"."oid")::"regclass" AS "relname",
"r"."oid" AS "relid",
"r"."reltoastrelid",
CASE
.
.
.
command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -D "/etc/postgresql/12/main" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1
2021-05-04 13:06:05.641 CEST [12861] LOG: received fast shutdown request
2021-05-04 13:06:05.641 CEST [12861] LOG: aborting any active transactions
waiting for server to shut down....2021-05-04 13:06:05.644 CEST [12861] LOG: background worker "logical replication launcher" (PID 12867) exited with exit code 1
2021-05-04 13:06:05.645 CEST [12863] LOG: shutting down
2021-05-04 13:06:05.657 CEST [12861] LOG: database system is shut down
done
server stopped
- Other upgrade methods (clone/dump) fails with the same errors.
OS info:
NAME="Ubuntu"
VERSION="20.04.2 LTS (Focal Fossa)"
Linux <server> 5.4.0-72-generic #80-Ubuntu SMP x86_64 x86_64 x86_64 GNU/Linux
Anyone seen similar issue?
Please advise.
Best regards,