-----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: [email protected] > [mailto:[email protected]] On Behalf Of > Sorbara, Giorgio (CIOK) Sent: Friday, February 14, 2014 5:49 AM To: > [email protected] 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 [email protected] > 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----- _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
