[postgis-users] Stuck with PostgreSQL/PostGIS Upgrade

Birgit Laggner birgit.laggner at thuenen.de
Tue Aug 13 07:56:32 PDT 2019

Dear list, 

on our test server, we currently try to test how to upgrade our PostgreSQL/PostGIS database. Sadly, we are stuck somewhere and would be very glad if anybody could help. 

Our test server is running on an Ubuntu 16.04 system in a virtual machine. We are coming from PostgreSQL 9.5.17 with PostGIS 2.3.3 and want to upgrade to PostgreSQL 11.2 and PostGIS 2.5. 

Here the outputs of the version queries: 
SELECT version(); 
"PostgreSQL 9.5.17 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~ 16.04.10 ) [ callto:5.4.0 20160609, 64 | 5.4.0 20160609, 64 ] -bit" 

SELECT postgis_full_version(); 
"POSTGIS="2.3.3 r15473" GEOS="3.5.1-CAPI-1.9.1 r4246" SFCGAL="1.2.2" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER" 

Our admin tried to upgrade PostGIS first and swears he did as told in the PostGIS manual. But apparently, the upgrade was not fully successful, since PostgreSQL still seems to look for PostGIS 2.3. 

His error message while trying to upgrade PostgreSQL is: 
postgres at gis ERROR: could not access file "$libdir/postgis-2.3": No such file or directory. 

Has anybody any idea what we are doing wrong and what we should be doing instead? 

With hopeful regards, 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190813/491d1df0/attachment.html>

More information about the postgis-users mailing list