Re: Upgrade from PG12 to PG - Mailing list pgsql-admin

From Ilya Kosmodemiansky
Subject Re: Upgrade from PG12 to PG
Date
Msg-id CAG95seWz3dJxKQPg4_3EAEBCXUuJTDpZBUKAp0+bqP2amQaZ9g@mail.gmail.com
Whole thread Raw
In response to Upgrade from PG12 to PG  (Jef Mortelle <jefmortelle@gmail.com>)
Responses Re: Upgrade from PG12 to PG
List pgsql-admin
Hi Jef,


On Thu, Jul 20, 2023 at 1:23 PM Jef Mortelle <jefmortelle@gmail.com> wrote:
> Looking at the dump file: man many lines like SELECT
> pg_catalog.lo_unlink('100000');
>
>
> I have the same issue with /usr/lib/postgresql15/bin/pg_upgrade -v -p
> 5431 -P 5432 -k
>
>
> Whats going on ?

pg_upgrade is known to be problematic with large objects.
Please take a look here to start with:
https://www.postgresql.org/message-id/20210309200819.GO2021%40telsasoft.com

>
>
> Kind regards
>
>
>



pgsql-admin by date:

Previous
From: Jef Mortelle
Date:
Subject: Upgrade from PG12 to PG
Next
From: Ron
Date:
Subject: Re: How to schedule long running SQL job