Hi Sandro, In the existing database it returns: "$libdir/postgis-2.1".
In a new database it returns: "$libdir/postgis-2.0". Also, when I create a new database I am able to create a postgis extension, and it works fine. select postgis_version() returns "2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1". So, the problem resides with existing databases where postgis stopped working. Any clues? Thank you very much. António 2013/6/7 Sandro Santilli <s...@keybit.net> > On Fri, Jun 07, 2013 at 12:27:39PM +0100, António M. Rodrigues wrote: > > Hey all, > > > > I have postgis 2.0.1-2 installed. > > > > Today I add ubuntugis stable repositories and amongst various updates, I > > noticed it re-installed postgis. > > > > Problem: With my existing database, postgis stopped working. > > > > Running select postgis_version() it complains saying: > > ERROR: could not access file "$libdir/postgis-2.1": No such file or > > directory > > > > Apparently this is only a problem with existing databases, not new ones ( > > > http://nelsonslog.wordpress.com/2013/04/13/postgis-upgrades-in-debian-ubuntu/ > > ). > > Sounds like a packaging bug to me. Do new databases use older postgis > library ? > Try this query, on the working and the non-working databases: > > select probin from pg_proc where proname = 'postgis_lib_version'; > > --strk; > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users