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 6:38 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> 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.

Do you by any chance have more than one version of PostgreSQL running
at the same time for different clusters? It kind of sounds like it's
picking up the wrong version at some point.

--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/