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

[António M. Rodrigues]

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 <strk at 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 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/20130607/2c8cc8b8/attachment.html>