[postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

[Sandro Santilli]

On Wed, Aug 23, 2023 at 10:08:23AM +0000, atanga MARCELIUS wrote:

> xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';
> ERROR:  extension "postgis" does not exist

The above message means that database "xxxxx" does not contain
the "postgis extension". This does not necessarely mean it doesn't
contain postgis objects, if you're coming from a very old install
as you seem to be coming from.

What does this query return?

  SELECT postgis_full_version();

And this one ?

  SELECT oid::regprocedure,probin
  FROM pg_catalog.pg_proc
  WHERE proname LIKE 'postgis_%version';

--strk;

  Libre GIS consultant/developer
  https://strk.kbt.io/services.html