Compatibility postgis

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Compatibility postgis
Date: 2023-08-22 07:35:04
Message-ID: CAJk5AtbuQv+p2rYgGLOZ4a=abhxVJz5AxAZn_o+s3Qe+4q3ksg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dulhaver 2023-08-22 11:33:09 Re: Compatibility postgis
Previous Message Rajesh Kumar 2023-08-18 12:49:18 Re: Autovacuum not working peoperly