Re: pg_upgrade issue, upgrading from v10 to v14

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(dot)dba(at)gmail(dot)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.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.
>>
>>