Re: pg_upgrade issue, upgrading from v10 to v14

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.5

and then connected to pg 14 and checked the extension.

postgres(at)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 postgis

postgres(at)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)

Thanks

On Thu, Jul 28, 2022 at 10:28 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

>
>
> On Wednesday, July 27, 2022, Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:
>
>> 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(at)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(at)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.
>
>