[postgis-users] Recent update to GDAL(?) broke PostGIS
Jayson Gallardo
jaysontrades at gmail.com
Wed Mar 12 14:45:23 PDT 2014
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>
More information about the postgis-users
mailing list