Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Date
Msg-id 20210504163820.GC27412@momjian.us
Whole thread Raw
In response to PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"  (Arne Henrik Segtnan <arne@basis-consulting.com>)
Responses Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
List pgsql-general
Tree view 
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@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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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

pgsql-general by date:

Previous
From: Arne Henrik Segtnan
Date:
Subject: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Next
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"