Обсуждение: Compatibility postgis
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
compatibility between postgres/GIS 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.
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:
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 errorcommand: "/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
compatibility between postgres/GIS 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.
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:
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 errorcommand: "/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
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.
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:
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 errorcommand: "/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
Posgis V3.0.1 is available in postgres version 12.
On Tue, 22 Aug, 2023, 5:34 PM vrms, <vrms@netcologne.de> wrote:
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 errorcommand: "/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