[postgis-users] Upgrading

[Robert Inder]

We have a number of databases (one per client) that use PostGIS.
They run on Centos 6.8 machines, Postgres 9.4, PostGIS 2.1.8.

Yum has just brought us PostGIS 2.2.5, and I am preparing to do the upgrade.

When I let yum upgrade the server to 2.2, the existing databases continue
to use 2.1.
As I'd hope/expect.

BUT...

The instructions on http://postgis.net/install tell me that to upgrade
PostGIS, I should say...

   ALTER EXTENSION postgis UPDATE;

When I do this, "SELECT PostGIS_full_version();" tells me the database is
using PostGIS 2.2.5.

But if I then back up the database, by doing a dump to SQL, the resulting
files still has many blocks like...

    CREATE FUNCTION addbbox(geometry) RETURNS geometry
        LANGUAGE c IMMUTABLE STRICT
        AS '$libdir/postgis-2.1', 'LWGEOM_addBBOX';

That "2.1" doesn't seem right.
Has something gone wrong without me noticing?
Is there something else I need to do?

ALSO...

If, after I have updated the server,  I restore a pre-update backup (dropdb
-> createdb -> load the SQL dump)
I get a database that is using 2.2.
It works.  But I'm worried that restoring the backup has not got me back to
where I started.

Robert.





















-- 
Robert Inder,                                    0131 229 1052 / 07808 492
213
Interactive Information Ltd,   3, Lauriston Gardens, Edinburgh EH3 9HH
Registered in Scotland, Company no. SC 150689
                                           Interactions speak louder than
words
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170603/919c40f7/attachment.html>