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

[Jayson Gallardo]

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


I found some suggestions about linking some .so files, but that didn't help
at all. So, I did some more digging. I still came up with nothing.

I then decided maybe I should try and update PostGIS  to see if that will
fix the problem. Unfortunately, that didn't work either. I tried to use the
extension updater, but it came back with:

ERROR:  could not open extension control file
"/usr/share/postgresql/9.1/extension/postgis.control": No such file or
directory


So, I thought about just dumping my data and starting from scratch. Well,
no luck there:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not access file
"$libdir/rtpostgis-2.0": No such file or directory
pg_dump: The command was: SELECT tableoid, oid, conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal FROM
pg_catalog.pg_constraint WHERE conrelid = '2706592'::pg_catalog.oid    AND
contype = 'c' ORDER BY conname
pg_dumpall: pg_dump failed on database "gallardo", exiting


Needless to say, I'm stumped. My data is actually pretty simple. I have a
database for osm data, another for 3m DEM data, and another for some random
shapefile data. I could theoretically start over, but I would really prefer
to keep the data I already have in place.

Would pg_upgrade help in this situation? Here is my pg_config:

BINDIR = /usr/lib/postgresql/9.1/bin
DOCDIR = /usr/share/doc/postgresql-doc-9.1
HTMLDIR = /usr/share/doc/postgresql-doc-9.1
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/9.1/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/9.1/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/9.1/man
SHAREDIR = /usr/share/postgresql/9.1
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-tcl' '--with-perl' '--with-python' '--with-pam'
'--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml'
'--with-libxslt' '--with-ldap' '--with-tclconfig=/usr/lib/tcl8.5'
'--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5'
'PYTHON=/usr/bin/python' '--mandir=/usr/share/postgresql/9.1/man'
'--docdir=/usr/share/doc/postgresql-doc-9.1'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/9.1'
'--bindir=/usr/lib/postgresql/9.1/bin' '--libdir=/usr/lib/'
'--libexecdir=/usr/lib/postgresql/' '--includedir=/usr/include/postgresql/'
'--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety'
'--enable-debug' '--disable-rpath' '--with-ossp-uuid' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-g
-O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Wformat-security
-Werror=format-security -fPIC -DLINUX_OOM_ADJ=0'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,--as-needed -Wl,-z,now'
'CPPFLAGS=-D_FORTIFY_SOURCE=2'
CC = gcc
CPPFLAGS = -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
-I/usr/include/tcl8.5
CFLAGS = -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat
-Wformat-security -Werror=format-security -fPIC -DLINUX_OOM_ADJ=0 -Wall
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv
-fexcess-precision=standard -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,--as-needed -Wl,-z,now
-L/usr/lib/x86_64-linux-gnu -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err
-lgssapi_krb5 -lz -ledit -lcrypt -ldl -lm
VERSION = PostgreSQL 9.1.12


and PostGIS version:

 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1


Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140312/bfb72fa3/attachment.html>