BUG #17850: could not load library "$libdir/postgis-2.4" could not load library "$libdir/rtpostgis-2.4":

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: roderick(dot)zuniga(at)gmail(dot)com
Subject: BUG #17850: could not load library "$libdir/postgis-2.4" could not load library "$libdir/rtpostgis-2.4":
Date: 2023-03-16 23:57:34
Message-ID: 17850-538f2fffe8c6a73c@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17850
Logged by: Roderick Zuñiga
Email address: roderick(dot)zuniga(at)gmail(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message 德哥 2023-03-17 02:34:53 Re:Re: BUG #17845: insert into on conflict bug .
Previous Message Peter Geoghegan 2023-03-16 20:32:46 Re: BUG #17846: pg_dump doesn't properly dump with paused WAL replay