pg_upgrade and generated column

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_upgrade and generated column
Date: 2025-03-03 13:50:19
Message-ID: CA+427g9iS7REZJYyVHR_kynzXa2pJb1hMDa1cuto-LHAGpGD6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

O/S is
Rocky Linux release 9.5

Command is
nohup time /usr/pgsql-16/bin/pg_upgrade -d /pgdata/pgsql/15/data -D
/pgdata/pgsql/16/data -b /usr/pgsql-15/bin -B /usr/pgsql-16/bin --retain
2>&1&

and
pg_upgrade fails with error:

...
pg_restore: from TOC entry 226; 1259 17061 TABLE m_access_cert_campaign
iamappadmin
pg_restore: error: could not execute query: ERROR: column "objecttype" in
child table must not be a generated column
Command was:
-- For binary upgrade, must preserve pg_type oid
SELECT
pg_catalog.binary_upgrade_set_next_pg_type_oid('17063'::pg_catalog.oid);
...

I can find some descriptions of the problems from internet,
but there are no instructions or recommendations on postgres.org,
what is the "correct" way to upgrade a db if it has a "generated column".
Some suggestion pls. Can i use pg_upgrade at all?

br
Kaido

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Imran Khan 2025-03-03 14:08:31 Re: pg_upgrade and generated column
Previous Message Edwin UY 2025-03-02 09:45:30 Re: Question about pg_dump + pg_restore + pg_toast