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

[Sandro Santilli]

On Fri, Jun 07, 2013 at 02:13:51PM +0100, António M. Rodrigues wrote:
> 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?

It looks like you _downgraded_ rather than upgraded your machine.
Did you install postgis-2.1 manually ? Re-install it again, if so.

--strk; 

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net