[postgis-users] soft upgrade 2.0.3 > 2.1.1

Jason jmathis at redzonesoftware.com
Tue Mar 18 14:52:00 PDT 2014

Hi All,

OS: centos 6.5
Postgres: 9.2.7
PostGIS: 2.0.3

We have recently finished cleaning up and consolidating apps/servers and 
upgraded to postgres 9.2.7. Now that postgres is upgraded we decided to get 
postgis upgraded as well; currently we are at 2.0.3. According to postgis 
docs we can do the "soft upgrade" path, which sounds wonderful. We used 
"create extension" for all our 2.0.3 databases.We are on centos 6.5 and I 
am using yum to update the postgis packages. I did a quick test on a vm 
that had a empty database and the postgis update went fine. After a little 
research I figured it was time to run the process on our dev node. The 
steps are:

yum install postgis2_92 #2.1.1
psql -c "ALTER EXTENSION postgis UPDATE TO '2.1.1';"

The yum installed went fine but the "alter extension" failed with: 
ERROR:  cannot drop function st_union(geometry) because other objects 
depend on it

It went on to list a few views that used that function. I tried dropping 
those views but it just moved on to other views that had postgis functions 
in them. Dropping all views is not worth it:) 

Does anyone know if soft upgrading from 2.0.3 > 2.1.1 is possible? Could it 
be something in our setup that is stopping us from upgrading. Otherwise it 
looks like a hard upgrade is in our future, and its hard to get excited 
about that. 



This transmission contains confidential and privileged information intended 
solely for the party identified above. If you receive this message in 
error, you must not use it or convey it to others. Please destroy it 
immediately and contact the sender at (303) 386-3955 or by return e-mail to 
the sender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140318/6f17c16d/attachment.html>

More information about the postgis-users mailing list