pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCompatibility postgis
5+ messages / 4 participants
[nested] [flat]
* Compatibility postgis
@ 2023-08-22 07:35 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-22 11:33 ` Re: Compatibility postgis dulhaver@mailbox.org
0 siblings, 1 reply; 5+ messages in thread
From: Rajesh Kumar @ 2023-08-22 07:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Compatibility postgis
2023-08-22 07:35 Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-08-22 11:33 ` dulhaver@mailbox.org
2023-08-22 11:37 ` Re: Compatibility postgis Gunnar Wagner <gunnar.wagner@mailbox.org>
0 siblings, 1 reply; 5+ messages in thread
From: dulhaver@mailbox.org @ 2023-08-22 11:33 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
compatibility between postgres/GIS 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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Compatibility postgis
2023-08-22 07:35 Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-22 11:33 ` Re: Compatibility postgis dulhaver@mailbox.org
@ 2023-08-22 11:37 ` Gunnar Wagner <gunnar.wagner@mailbox.org>
2023-08-22 12:03 ` Re: Compatibility postgis vrms <vrms@netcologne.de>
0 siblings, 1 reply; 5+ messages in thread
From: Gunnar Wagner @ 2023-08-22 11:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
compatibility between postgres/GIS 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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Compatibility postgis
2023-08-22 07:35 Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-22 11:33 ` Re: Compatibility postgis dulhaver@mailbox.org
2023-08-22 11:37 ` Re: Compatibility postgis Gunnar Wagner <gunnar.wagner@mailbox.org>
@ 2023-08-22 12:03 ` vrms <vrms@netcologne.de>
2023-08-23 09:25 ` Re: Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: vrms @ 2023-08-22 12:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Compatibility postgis
2023-08-22 07:35 Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-22 11:33 ` Re: Compatibility postgis dulhaver@mailbox.org
2023-08-22 11:37 ` Re: Compatibility postgis Gunnar Wagner <gunnar.wagner@mailbox.org>
2023-08-22 12:03 ` Re: Compatibility postgis vrms <vrms@netcologne.de>
@ 2023-08-23 09:25 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Rajesh Kumar @ 2023-08-23 09:25 UTC (permalink / raw)
To: vrms <vrms@netcologne.de>; +Cc: pgsql-admin@lists.postgresql.org
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
> <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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-08-23 09:25 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-22 07:35 Compatibility postgis Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-22 11:33 ` dulhaver@mailbox.org
2023-08-22 11:37 ` Gunnar Wagner <gunnar.wagner@mailbox.org>
2023-08-22 12:03 ` vrms <vrms@netcologne.de>
2023-08-23 09:25 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox