[postgis-devel] ALTER EXTENSION postgis UPGRADE to '2.1.0'

[Julio Rodriguez]

Hello.
Would like input on the following procedure taken to upgrade PostGIS from 2.0 to 2.1 on a postgres 9.1 server (with CentOs 6.3)
We don't want to compile the source and install it on every server; we need a package that will enable us to deploy in much faster way in other servers.


1.       Compile and install postgis 2.1 from source file on a different server having postgres 9.1.

a.       This will generate your libraries for the server PostGres version 9.1

2.       Now in the other server(s) you want to upgrade PostGIS to 2.1

a.       Update all the libraries required by PostGIS version 2.1

                                                               i.      yum install proj

                                                             ii.      yum install gdal-1.9.2-4.el6.x86_64

                                                            iii.      all others required

3.       Yum install postgis

4.       Copy files from pgsql-9.2/share/extension to pgsql-9.1/share/extension

a.       postgis--2.0.4--2.1.0.sql

b.      postgis_topology--2.0.4--2.1.0.sql

5.       Copy the following libraries from the server where you compiled and installed previously postgis to the server you are upgrading PostGIS. They might be located in pgsql-9.1/lib

a.       tpostgis-2.1.so

b.      rtpostgis-2.0.so

6.       Connect to the DB and execute the soft upgrade

a.       ALTER EXTENSION postgis UPDATE TO '2.1.0';

b.      ALTER EXTENSION postgis_topology UPDATE TO '2.1.0';

7.       SELECT PostGIS_Full_Version(); you should see the new version installed.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20131001/9e1dc0f7/attachment.html>