[postgis-users] Recent update to GDAL(?) broke PostGIS

[Jayson Gallardo]

This is what I get:

~$ dpkg -s postgis
Package: postgis
Status: install ok installed
Priority: optional
Section: misc
Installed-Size: 639
Maintainer: Debian GIS Project <pkg-grass-devel at lists.alioth.debian.org>
Architecture: amd64
Version: 2.0.3-2~precise4
Depends: libc6 (>= 2.14), libgdal1h (>= 1.9.0), libgeos-c1 (>= 3.3.8),
liblwgeom-2.0.3 (>= 2.0.0), libpq5
Suggests: postgresql-9.1-postgis-2.0
Description: Geographic objects support for PostgreSQL
 PostGIS adds support for geographic objects to the PostgreSQL
 object-relational database. In effect, PostGIS "spatially enables"
 the PostgreSQL server, allowing it to be used as a backend spatial
 database for geographic information systems (GIS), much like ESRI's
 SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS
 "Simple Features Specification for SQL".
 .
 This package contains the PostGIS userland binaries, common files.
Homepage: http://postgis.refractions.net/


I am carefully going through installing PostgreSQL 9.3 and then pg_upgrade
to see if I can migrate the data over...


On Wed, Mar 12, 2014 at 4:42 PM, Andy Colson <andy at squeakycode.net> wrote:

> Sounds like the postgis package was uninstalled.  My debian foo is not
> strong, but does something like this return anything:
>
> dpkg -s postgis
> or
> dpkg-query -l 'postgis*'
>
>
> -Andy
>
>
> On 3/12/2014 2:38 PM, Jayson Gallardo wrote:
>
>> That's the thing. I don't have a rtpostgis-2.x.so
>> <http://rtpostgis-2.x.so> anywhere on my system. I'm pretty sure it was
>>
>> there before, because everything worked fine. And it may not even be
>> GDAL. I checked with the server admin and that was the only thing that
>> should have affected our setup.
>>
>>
>> On Wed, Mar 12, 2014 at 2:11 PM, Andy Colson <andy at squeakycode.net
>> <mailto:andy at squeakycode.net>> wrote:
>>
>>     On 3/12/2014 12:43 PM, Jayson Gallardo wrote:
>>
>>         A while ago, our Ubuntu server was updated. One of the updates
>>         included
>>         an update to gdal 1.10. Ever since then, our application no longer
>>         works. PostGIS throws an error:
>>
>>              select postgis_full_version();
>>              ERROR:  could not access file "$libdir/rtpostgis-2.0": No
>>         such file
>>              or directory
>>              CONTEXT:  SQL statement "SELECT postgis_gdal_version()"
>>              PL/pgSQL function "postgis_full_version" line 22 at SQL
>>         statement
>>
>>
>>
>>
>>     How about reverting back to the prior gdal?
>>
>>     I assume the problem is rtpostgis-2.1.so <http://rtpostgis-2.1.so>
>>
>>     is linked to gdal 1.9 or something.  You can check with "ldd
>>     rtpostgis-2.1.so <http://rtpostgis-2.1.so>"
>>
>>     I dunno where your rtpostgis-2.1.so <http://rtpostgis-2.1.so> would
>>     be.  Mine is in:
>>       /usr/local/pgsql/lib/__postgresql
>>
>>
>>     But your certainly wont be there.
>>
>>     -Andy
>>     _________________________________________________
>>     postgis-users mailing list
>>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>>     http://lists.osgeo.org/cgi-__bin/mailman/listinfo/postgis-__users
>>     <http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users>
>>
>>
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140312/736b684d/attachment.html>