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

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.