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

[Paragon Corporation]

Frank,
You don't need to use postgis_restore.pl if you are restoring just tables
with geometries.  Doesn't hurt to use it though.

What postgis_restore.pl does is exclude restoring postgis packaged
functions, types, operators etc. and also renames deprecated table
constraints.  If you do a simple restore over a new postgis, you'll get
ambiguous function name conflicts.

What I did forget to mention in last post is that if you are coming from
PostGIS 1.5, you'll probably want to install

legacy.sql

File.

So steps

Create extension postgis;
Install legacy.sql

Restore your data - if you restore the whole backup that contains postgis
old functions -- use postgis_restore.pl (otherwise you can get away with
just using pg_restore).

Hope that helps,
Regina
http://www.postgis.us
http://postgis.net




-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Frank Broniewski
Sent: Wednesday, February 19, 2014 3:01 AM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Upgrade postgres 9.0 -> 9.3
mantainingpostgis1.5?

-----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-----
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users