[postgis-users] Problem with postgis upgrade (ubuntu 12.04)

[Sandro Santilli]

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;