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

[Frank Broniewski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Regina,

I've had a similar question a few days ago and unfortunately no reply
so far. When you write

> reload your PostGIS tables

do you mean to use the postgis_restore.pl script to do that? My
package / software system will only let me upgrade both Postgresql
(from 9.0 to 9.3) and Postgis (from 1.5 to 2.1) at once and not one
after another so I am looking for a solution on how to get by upgrade
done smoothly

Thanks,

Frank

Am 2014-02-18 11:41, schrieb 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
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________ postgis-users
> mailing list postgis-users at lists.osgeo.org 
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 


- -- 
Frank BRONIEWSKI

METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN

tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.metrico.lu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJTBGSoAAoJEHopqW0d1cQVYTIIANJWjdroqBsqQTRuOybNG52W
WF8nyk5d9GiMhtwP0DXAulTVGVp/FNkUoheqTiL9aEKvlvJJzj4I40qe8CJ80g8b
sS0a7zqAL3Cd907Yuyi/xhHkJZlHf8E+EODCT3pFhfkg8JGSx4cqWHdhL237AJeC
CIRd2aLYl/Srl8EK4jp23JEFAQInYN0XKjnmEggZtYdTNjUnYiMsqK+w9gKiVV4A
qG23kfGdUvWNeUxEVD8BmCevNl3+DTsLqdA+cAJmR7/lhtokGs9fcEfpPEERMOiG
K6JKu++zxjX0KAp3M6dcSBjZendliNjbDKzgs6SyhUOjrxc84EcQzKnJKoF4HDg=
=bWv7
-----END PGP SIGNATURE-----