Upgrade from PG12 to PG

From: Jef Mortelle <jefmortelle(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Upgrade from PG12 to PG
Date: 2023-07-20 11:22:55
Message-ID: 3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I want to upgrade from PG12 to P15.

I use /usr/lib/postgresql15/bin/pg_upgrade -v -p 5431 -P 5432

I takes a lot of time, more than 6 hours

Log file, al lot of  lines pg_restore: executing BLOB 1

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 ?

Kind regards

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ilya Kosmodemiansky 2023-07-20 11:43:13 Re: Upgrade from PG12 to PG
Previous Message M Sarwar 2023-07-20 01:25:10 Re: How to schedule long running SQL job