From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: roderick.zuniga@gmail.com
Subject: BUG #17850: could not load library "$libdir/postgis-2.4" could not load library "$libdir/rtpostgis-2.4":
Date: Thu, 16 Mar 2023 23:57:34 +0000
Message-ID: <17850-538f2fffe8c6a73c@postgresql.org> (raw)
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
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, roderick.zuniga@gmail.com
Subject: Re: BUG #17850: could not load library "$libdir/postgis-2.4" could not load library "$libdir/rtpostgis-2.4":
In-Reply-To: <17850-538f2fffe8c6a73c@postgresql.org>
* 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