Re: Compatibility postgis

Posgis V3.0.1 is available in postgres version 12.

On Tue, 22 Aug, 2023, 5:34 PM vrms, <vrms(at)netcologne(dot)de> wrote:

>
> compatibility between postgres/GIS as well as upgrading is a little
> tricky.
> This
> <https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS#PostGISSupportMatrix>
> is a good starting point to see what you have to aim for.
>
> Next challenge is to figure out a workable upgrade path as it is not
> unlikely you will have to go through some intermediate steps.
>
> Maybe it would help whether you can specify which PostGIS version you are
> coming from on the source (postgres-12) Installation.
>
> On 22.08.23 09:35, Rajesh Kumar wrote:
>
> I am tring to upgrade from postgres 12 to postgres 15.
>
> And it seems like posigis extension I have on V12 is not compatible with
> V15.
>
> I get following error
>
>
> command: "/usr/pgsql-15/bin/pg_dump" --host /var/lib/pgsql --port 50432
> --username postgres --schema-only --quote-all-identifiers --binary-upgrade
> --format=cu stom
> --file="/var/lib/pgsql/data/15/data/pg_upgrade_output.d/20230818T082920.083/dump/pg_upgrade_dump_27286.custom"
> 'dbname=common' >> "/var/lib/pgsql/data/1
> 5/data/pg_upgrade_output.d/20230818T082920.083/log/pg_upgrade_dump_27286.log"
> 2>&1 pg_dump: error: query failed: ERROR: could not access file
> "$libdir/postgis-3": No such file or directory
>
>