[postgis-users] Upgrade postgres 9.0 -> 9.3 mantaining postgis1.5?

[Paragon Corporation]

Giorgio,
 
For 9.2 you can install 1.5.6+ (though we frown on people using 1.5 with
9.2) . 9.3+ supports only 2.1+
 
Refer to the Support Matrix for details
 
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
 
 
 
Regarding if you can dump table with geometries, putting aside tables with
no reference to postgis whatsoever -- yes you can.
 
1) In theory you could just do a pg_upgrade (you might have to drop your
postgis tables and uninstall postgis first) -> 9.3
 
Then install PostGIS 2.1 on your new server and reload your postgis tables
 
or
 
2) backup your postgis tables, uninstall PostGIS 1.5, install PostGIS 2.1,
reload your PostGIS tables --> then pg_upgrade over to 9.3
 
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Sorbara, Giorgio
(CIOK)
Sent: Friday, February 14, 2014 5:49 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Upgrade postgres 9.0 -> 9.3 mantaining postgis1.5?



Dear all,

 

I am about to upgrade postgres from 9.0 to 9.3 but the gis team would like
to maintain postgis 1.5 version.

>From what I have browsed around it seems that as of the 9.2 version only 2.0
is supported.

Can you confirm this?

 

If that is correct I need to upgrade 1.5 -> 2.0 before upgrading the server,
so far so good.

Then comes another question. the only way to upgrade is to dump and reimport
databases.

Now it happens that we have tables with geometries which count roughly 10000
records, but in the same database we have tables with billions records
(which I would like not to dump)

 

Is it possible for the sake of upgrading postgis, to just dump tables with
geometries, putting aside tables with no reference to postgis whatsoever?

 

thank you,

g

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140218/b62f4875/attachment.html>