The following bug has been logged on the website:
Bug reference: 17850
Logged by: Roderick Zuñiga
Email address: roderick.zuniga@gmail.com
PostgreSQL version: 14.7
Operating system: Red Hat Enterprise Linux Server release 7.4 (Maipo
Description:
I am trying to update the version of postgres 9.6 to version 14, but when
performing the validation it gives me the following error
-bash-4.2$ cat loadable_libraries.txt
could not load library "$libdir/postgis-2.4": ERROR: could not access file
"$libdir/postgis-2.4": No such file or directory
In database: sdc_dev
could not load library "$libdir/rtpostgis-2.4": ERROR: could not access
file "$libdir/rtpostgis-2.4": No such file or directory
In database: sdc_dev
source database extension
sdc_dev=# \dx
List of installed extensions
Name | Version | Schema |
Description
--------------------+---------+------------+---------------------------------------------------------------------
dblink | 1.2 | public | connect to other PostgreSQL
databases from within a database
pg_stat_statements | 1.4 | public | track execution statistics of
all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 2.4.4 | public | PostGIS geometry, geography,
and raster spatial types and functions
unaccent | 1.1 | public | text search dictionary that
removes accents
validation command
/usr/pgsql-14/bin/pg_upgrade -b /usr/pgsql-9.6/bin -B /usr/pgsql-14/bin -d
/var/lib/pgsql/9.6/data -D /var/lib/pgsql/14/data -c