On Wednesday, July 27, 2022, Daulat <
daulat.dba@gmail.com> wrote:
Hi Team,
Please help on the postgres upgrade issue. We are upgrading from v10 to v14
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:
loadable_libraries.txt
Failure, exiting
postgres@test-Lenovo-C40-30:/etc/postgresql/10$ cat loadable_libraries.txt
could not load library "$libdir/postgis-2.5": ERROR: could not access file "$libdir/postgis-2.5": No such file or directory
In database: Test_DB
could not load library "$libdir/rtpostgis-2.5": ERROR: could not access file "$libdir/rtpostgis-2.5": No such file or directory
In database: Test_DB
postgres@test-Lenovo-C40-30:/etc/postgresql/10
IOW, you are using PostGIS, read their documentation and inspect their version matrix and decide on an upgrade path you want to follow, ensuring that when you run pg_upgrade the same version of PostGIS exists in the old and new clusters.
Or take the first option and uninstall PostGIS on the existing server.
David J.