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
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 |