Hi,
Thanks a lot for the feedback, which actually solved the problem. After executing the below command, upgrade from 10 to 12 worked perfectly fine.
pgsqldb=# DROP EXTENSION pg_repack CASCADE;
Med vennlig hilsen / Best regards,
_______________________
Arne Henrik Segtnan
On Tue, May 4, 2021 at 12:43:36PM -0400, Tom Lane wrote:Arne Henrik Segtnan <arne@basis-consulting.com> writes:
When trying to upgrade from PostgreSQL 10 to 12, the installation fails as shown below.
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
.
.
.
You didn't show us the rest of the command, but it looks like
this view contains a reference to pg_class.relhasoids. As
Bruce noted, that column no longer exists, so you're not going
to be able to transparently upgrade this view.
I don't know what this view is from, though the schema name
"repack" is suggestive. Possibly you could drop whatever it's
a part of, and then reinstall an updated version after upgrading?
Yeah, Tom, I think you are on to something. I couldn't figure out wherethe r.relhasoids was referenced in the rest of the log output, but if itis on the lines that are part of CREATE VIEW, it certainly could be thecase that the view references a pre-PG-12 column of pg_class. To fixit, Tom is right that removing the view then recreating it with PG-12pg_class column assumptions is the right fix. I actually rarely seethis kind of failure.-- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
