[postgis-devel] Upgrade PG 9.3 to 9.5 with PostGIS issue

[Blumentrath, Stefan]

Many thanks.

The query returns a list of 153, quite basic functions, e.g.:
"buffer(geometry, double precision)"
"buildarea(geometry)"
"centroid(geometry)"
"contains(geometry, geometry)"
"convexhull(geometry)"
"crosses(geometry, geometry)"
"difference(geometry, geometry)"
"dimension(geometry)"
"disjoint(geometry, geometry)"
"distance(geometry, geometry)"
"distance_sphere(geometry, geometry)"
"distance_spheroid(geometry, geometry, spheroid)"
"dump(geometry)"
"dumprings(geometry)"

Does that mean the upgrade of the extension failed locally?
Do I have to run some sql scripts from /usr/share/postgresql/9.5/extension/ manually?

Cheers
Stefan

-----Original Message-----
From: Sandro Santilli [mailto:sandro.santilli at gmail.com] On Behalf Of Sandro Santilli
Sent: 5. april 2016 10:04
To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Cc: Blumentrath, Stefan <Stefan.Blumentrath at nina.no>
Subject: Re: [postgis-devel] Upgrade PG 9.3 to 9.5 with PostGIS issue

On Tue, Apr 05, 2016 at 06:22:32AM +0000, Blumentrath, Stefan wrote:

> “Could not load library "$libdir/postgis-2.1" ERROR: could not access file "$libdir/postgis-2.1": No such file or directory”

[...]

> Any ideas how to fix this or how to identify the conflicting functions?

SELECT format('%s(%s)', proname, pg_get_function_arguments(oid))
  FROM pg_proc
 WHERE probin = '$libdir/postgis-2.1';

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html