Thread: pg_upgrade issue, upgrading from v10 to v14
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
Thanks
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 v14Message:Your installation references loadable libraries that are missing from thenew installation. You can add these libraries to the new installation,or remove the functions using them from the old installation. A list ofproblem libraries is in the file:loadable_libraries.txtFailure, exitingpostgres@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 directoryIn database: Test_DBcould not load library "$libdir/rtpostgis-2.5": ERROR: could not access file "$libdir/rtpostgis-2.5": No such file or directoryIn database: Test_DBpostgres@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.
Hi David,
postgres@zuber-Lenovo-C40-30:~$ psql -U postgres -p 5436
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions
postgres@zuber-Lenovo-C40-30:~$ psql -U postgres -p 5436
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions
During upgrade, we are still getting the same error message.
I have followed the following steps on Postgres14.
- Installed postgis version. sudo apt install postgresql-14-postgis-2.5
and then connected to pg 14 and checked the extension.
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions
(2 rows)
If i create a new database and tried to create extension postgis
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions
(2 rows)
Thanks
On Thu, Jul 28, 2022 at 10:28 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
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 v14Message:Your installation references loadable libraries that are missing from thenew installation. You can add these libraries to the new installation,or remove the functions using them from the old installation. A list ofproblem libraries is in the file:loadable_libraries.txtFailure, exitingpostgres@test-Lenovo-C40-30:/etc/postgresql/10$ cat loadable_libraries.txtcould not load library "$libdir/postgis-2.5": ERROR: could not access file "$libdir/postgis-2.5": No such file or directoryIn database: Test_DBcould not load library "$libdir/rtpostgis-2.5": ERROR: could not access file "$libdir/rtpostgis-2.5": No such file or directoryIn database: Test_DBpostgres@test-Lenovo-C40-30:/etc/postgresql/10IOW, 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.
Hi David,
I have moved one step ahead by installing postgis v.3 on the PG14 instance and now able to create the postgis extension under a new database.
I did not see any error during upgrade but functions are missing from v14.
Thanks,
On Mon, Aug 1, 2022 at 2:44 PM Daulat <daulat.dba@gmail.com> wrote:
Hi David,During upgrade, we are still getting the same error message.I have followed the following steps on Postgres14.- Installed postgis version. sudo apt install postgresql-14-postgis-2.5and then connected to pg 14 and checked the extension.postgres@zuber-Lenovo-C40-30:~$ psql -U postgres -p 5436
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions(2 rows)If i create a new database and tried to create extension postgispostgres@zuber-Lenovo-C40-30:~$ psql -U postgres -p 5436
psql (14.4 (Ubuntu 14.4-1.pgdg18.04+1))
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.2.1 | public | PostGIS geometry and geography spatial types and functions(2 rows)ThanksOn Thu, Jul 28, 2022 at 10:28 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
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 v14Message:Your installation references loadable libraries that are missing from thenew installation. You can add these libraries to the new installation,or remove the functions using them from the old installation. A list ofproblem libraries is in the file:loadable_libraries.txtFailure, exitingpostgres@test-Lenovo-C40-30:/etc/postgresql/10$ cat loadable_libraries.txtcould not load library "$libdir/postgis-2.5": ERROR: could not access file "$libdir/postgis-2.5": No such file or directoryIn database: Test_DBcould not load library "$libdir/rtpostgis-2.5": ERROR: could not access file "$libdir/rtpostgis-2.5": No such file or directoryIn database: Test_DBpostgres@test-Lenovo-C40-30:/etc/postgresql/10IOW, 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.