Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Arne Henrik Segtnan <arne(at)basis-consulting(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Date: 2021-05-04 16:38:20
Message-ID: 20210504163820.GC27412@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 4, 2021 at 06:29:17PM +0200, Arne Henrik Segtnan wrote:
> 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(at)zabbix_db ERROR: column
> r.relhasoids does not exist at character 1616

pg_class.relhasoids was removed in PG 12.

> - Other upgrade methods (clone/dump) fails with the same errors.

OK, so the problem is really pg_dump.

> Anyone seen similar issue?

Nope, something very odd going on here.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-05-04 16:40:02 Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Previous Message Arne Henrik Segtnan 2021-05-04 16:29:17 PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"