From: "Regina Obe" <lr@pcorp.us>
To: "'PostgreSQL on Debian and Ubuntu'"
 <pgsql-pkg-debian@lists.postgresql.org>
Subject: Wrong path to loaded_libraries upgrading from PostgreSQL 17 to
 PostgreSQL 18
Date: Sat, 27 Sep 2025 22:13:23 -0400
Message-ID: <000001dc301d$78d7b6a0$6a8723e0$@pcorp.us>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AdwwHSTnqeDiyN51TP2z0TDMGPgTmQ==
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/000001dc301d%2478d7b6a0%246a8723e0%24%40pcorp.us>
Precedence: bulk

In trying to upgrade my instance from PostgreSQL 17 to 18

I get this message

Your installation references loadable libraries that are missing from the
new installation.  You can add these libraries to the new installation,
or remove the functions using them from the old installation.  A list of
problem libraries is in the file:
 
/var/lib/postgresql/18/main/pg_upgrade_output.d/20250927T220622.019/loadable
_libraries.txt
Failure, exiting
pg_upgradecluster: pg_upgrade output scripts are in
/var/log/postgresql/pg_upgradecluster-17-18-main.pYaN


When I try to go to the path
/var/lib/postgresql/18/main/pg_upgrade_output.d/20250927T220622.019/loadable
_libraries.txt

The file does not exist, however I do see a file:

in
/var/log/postgresql/pg_upgradecluster-17-18-main.pYaN/loadable_libraries.txt

Is the given path just wrong or am I missing something?

Thanks,
Regina