Re: Upgrade from PG12 to PG

From: Ilya Kosmodemiansky <ik(at)dataegret(dot)com>
To: Jef Mortelle <jefmortelle(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Upgrade from PG12 to PG
Date: 2023-07-20 11:43:13
Message-ID: CAG95seWz3dJxKQPg4_3EAEBCXUuJTDpZBUKAp0+bqP2amQaZ9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Jef,

On Thu, Jul 20, 2023 at 1:23 PM Jef Mortelle <jefmortelle(at)gmail(dot)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
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-07-20 13:26:39 Re: How to schedule long running SQL job
Previous Message Jef Mortelle 2023-07-20 11:22:55 Upgrade from PG12 to PG