Re: pg_upgrade issue, upgrading from v10 to v14 - Mailing list pgsql-admin
| From | Daulat |
|---|---|
| Subject | Re: pg_upgrade issue, upgrading from v10 to v14 |
| Date | |
| Msg-id | CALfOM6J=M2GuqixoLudsffTV+EfC2xCjytX_ybEgUhX+EKzSYQ@mail.gmail.com Whole thread Raw |
| In response to | Re: pg_upgrade issue, upgrading from v10 to v14 ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Responses |
Re: pg_upgrade issue, upgrading from v10 to v14
(Daulat <daulat.dba@gmail.com>)
|
| List | pgsql-admin |
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.
pgsql-admin by date: