From: Jef Mortelle <jefmortelle@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Upgrade from PG12 to PG
Date: Thu, 20 Jul 2023 13:22:55 +0200
Message-ID: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jefmortelle@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade from PG12 to PG
In-Reply-To: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox