On Wed, Nov 09, 2016 at 09:18:06PM +0100, Paolo Importuni wrote:
> The soft upgrade works "ALTER EXTENSION postgis UPDATE TO '2.2.2';" works
> only if the db instance was spatially enabled by running the script "CREATE
> EXTENSION POSTGIS"
> In case it wasn´t and as strk suggested, run the followi
Sorry strk, it worked! I was doing something wrong.
So resume for anyone interested:
I was trying to migrate from postgis 2.0 to 2.2
I successfully installed the postgis static library and had the migration
script in place.
The soft upgrade works "ALTER EXTENSION postgis UPDATE TO '2.2.2';" works
2016-11-09 20:27 GMT+01:00 Sandro Santilli :
> On Wed, Nov 09, 2016 at 06:33:28PM +0100, Paolo Importuni wrote:
> > 2016-11-09 12:06 GMT+01:00 Sandro Santilli :
> > > On Wed, Nov 09, 2016 at 11:44:53AM +0100, Paolo Importuni wrote:
> > > >
> > > > I've just tried but it complains that
> > > > "ERR
On Wed, Nov 09, 2016 at 06:33:28PM +0100, Paolo Importuni wrote:
> 2016-11-09 12:06 GMT+01:00 Sandro Santilli :
> > On Wed, Nov 09, 2016 at 11:44:53AM +0100, Paolo Importuni wrote:
> > >
> > > I've just tried but it complains that
> > > "ERROR: type "raster" does not exist"
> >
> > This is becaus
Hi strk,
still problems, it says:
"You need to install postgresql-server-dev-X.Y for building a server-side
extension or libpq-dev for building a client-side application"
Do I need to apt-install postgresql-server-dev-X.Y? What's the use?
Thanks again
Paolo
2016-11-09 12:06 GMT+01:00 Sandro San
On Wed, Nov 09, 2016 at 11:44:53AM +0100, Paolo Importuni wrote:
> Hi strk,
> I've just tried but it complains that
> "ERROR: type "raster" does not exist"
This is because postgis _EXTENSION_ is forced to have
also raster in it :(
So the fix is for you to load raster script for 2.0.0
psql -f `p
Hi strk,
I've just tried but it complains that
"ERROR: type "raster" does not exist"
Thanks for helping
Paolo
--
Paolo Importuni
Software Analyst and Developer
Modena, Italy
2016-11-09 11:12 GMT+01:00 Sandro Santilli :
> On Wed, Nov 09, 2016 at 09:45:59AM +0100, Paolo Importuni wrote:
>
> > I
On Wed, Nov 09, 2016 at 09:45:59AM +0100, Paolo Importuni wrote:
> I am trying to migrate my postgres/postgis instance from 2.0 to 2.2.2
> The new postgis.so library is in the right place and I found the right
> migration script postgis-2.0.0--2.2.2.sql.
>
> I successfully upgraded three db inst
Hi all,
I am trying to migrate my postgres/postgis instance from 2.0 to 2.2.2
The new postgis.so library is in the right place and I found the right
migration script postgis-2.0.0--2.2.2.sql.
I successfully upgraded three db instances by using the "ALTER EXTENSION
postgis UPDATE TO '2.2.2';" co
