<div dir="ltr"><div><font face="arial, helvetica, sans-serif">This is what I get:</font></div><div><font face="courier new, monospace"><br></font></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><font face="courier new, monospace">~$ dpkg -s postgis</font></div>
<div><font face="courier new, monospace">Package: postgis</font></div><div><font face="courier new, monospace">Status: install ok installed</font></div><div><font face="courier new, monospace">Priority: optional</font></div>
<div><font face="courier new, monospace">Section: misc</font></div><div><font face="courier new, monospace">Installed-Size: 639</font></div><div><font face="courier new, monospace">Maintainer: Debian GIS Project <<a href="mailto:pkg-grass-devel@lists.alioth.debian.org">pkg-grass-devel@lists.alioth.debian.org</a>></font></div>
<div><font face="courier new, monospace">Architecture: amd64</font></div><div><font face="courier new, monospace">Version: 2.0.3-2~precise4</font></div><div><font face="courier new, monospace">Depends: libc6 (>= 2.14), libgdal1h (>= 1.9.0), libgeos-c1 (>= 3.3.8), liblwgeom-2.0.3 (>= 2.0.0), libpq5</font></div>
<div><font face="courier new, monospace">Suggests: postgresql-9.1-postgis-2.0</font></div><div><font face="courier new, monospace">Description: Geographic objects support for PostgreSQL</font></div><div><font face="courier new, monospace"> PostGIS adds support for geographic objects to the PostgreSQL</font></div>
<div><font face="courier new, monospace"> object-relational database. In effect, PostGIS "spatially enables"</font></div><div><font face="courier new, monospace"> the PostgreSQL server, allowing it to be used as a backend spatial</font></div>
<div><font face="courier new, monospace"> database for geographic information systems (GIS), much like ESRI's</font></div><div><font face="courier new, monospace"> SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS</font></div>
<div><font face="courier new, monospace"> "Simple Features Specification for SQL".</font></div><div><font face="courier new, monospace"> .</font></div><div><font face="courier new, monospace"> This package contains the PostGIS userland binaries, common files.</font></div>
<div><font face="courier new, monospace">Homepage: <a href="http://postgis.refractions.net/">http://postgis.refractions.net/</a></font></div></blockquote><div><br></div><div>I am carefully going through installing PostgreSQL 9.3 and then pg_upgrade to see if I can migrate the data over...</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Mar 12, 2014 at 4:42 PM, Andy Colson <span dir="ltr"><<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Sounds like the postgis package was uninstalled. My debian foo is not strong, but does something like this return anything:<br>
<br>
dpkg -s postgis<br>
or<br>
dpkg-query -l 'postgis*'<br>
<br>
<br>
-Andy<div class=""><br>
<br>
On 3/12/2014 2:38 PM, Jayson Gallardo wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">
That's the thing. I don't have a <a href="http://rtpostgis-2.x.so" target="_blank">rtpostgis-2.x.so</a><br></div>
<<a href="http://rtpostgis-2.x.so" target="_blank">http://rtpostgis-2.x.so</a>> anywhere on my system. I'm pretty sure it was<div class=""><br>
there before, because everything worked fine. And it may not even be<br>
GDAL. I checked with the server admin and that was the only thing that<br>
should have affected our setup.<br>
<br>
<br>
On Wed, Mar 12, 2014 at 2:11 PM, Andy Colson <<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a><br></div><div class="">
<mailto:<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a>>> wrote:<br>
<br>
On 3/12/2014 12:43 PM, Jayson Gallardo wrote:<br>
<br>
A while ago, our Ubuntu server was updated. One of the updates<br>
included<br>
an update to gdal 1.10. Ever since then, our application no longer<br>
works. PostGIS throws an error:<br>
<br>
select postgis_full_version();<br>
ERROR: could not access file "$libdir/rtpostgis-2.0": No<br>
such file<br>
or directory<br>
CONTEXT: SQL statement "SELECT postgis_gdal_version()"<br>
PL/pgSQL function "postgis_full_version" line 22 at SQL<br>
statement<br>
<br>
<br>
<br>
<br>
How about reverting back to the prior gdal?<br>
<br></div>
I assume the problem is <a href="http://rtpostgis-2.1.so" target="_blank">rtpostgis-2.1.so</a> <<a href="http://rtpostgis-2.1.so" target="_blank">http://rtpostgis-2.1.so</a>><div class=""><br>
is linked to gdal 1.9 or something. You can check with "ldd<br></div>
<a href="http://rtpostgis-2.1.so" target="_blank">rtpostgis-2.1.so</a> <<a href="http://rtpostgis-2.1.so" target="_blank">http://rtpostgis-2.1.so</a>>"<br>
<br>
I dunno where your <a href="http://rtpostgis-2.1.so" target="_blank">rtpostgis-2.1.so</a> <<a href="http://rtpostgis-2.1.so" target="_blank">http://rtpostgis-2.1.so</a>> would<br>
be. Mine is in:<br>
/usr/local/pgsql/lib/__<u></u>postgresql<div class=""><br>
<br>
But your certainly wont be there.<br>
<br>
-Andy<br></div>
______________________________<u></u>___________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/cgi-__bin/mailman/listinfo/postgis-__users" target="_blank">http://lists.osgeo.org/cgi-__<u></u>bin/mailman/listinfo/postgis-_<u></u>_users</a><br>
<<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a>><div class=""><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
</div></div></blockquote></div><br></div>