Postgres Pro
Downloads
Home   >   mailing lists

Re: Compatibility postgis - Mailing list pgsql-admin

From vrms
Subject Re: Compatibility postgis
Date
Msg-id 0242964f-7cc2-4172-81ca-e05a7f8ee613@netcologne.de
Whole thread Raw
In response to Compatibility postgis  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Compatibility postgis
List pgsql-admin
Tree view

compatibility between postgres/GIS as well as upgrading is a little tricky.
This 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

pgsql-admin by date:

Previous
From: Gunnar Wagner
Date:
Subject: Re: Compatibility postgis
Next
From: Rajesh Kumar
Date:
Subject: Re: Compatibility postgis