Re: Upgrading from postgreSQL 9.1.6 to 9.3

<span style=3D"font-family:Verdana; color:#000000; font-size:10=
pt;">1.) We have to upgrade four 9.1 database instances, so is using p=
g_upgrade still the way to go? Our prior upgrade methodology when we moved =
from pg 8.4.3 to 9.1.6 was to use the hard links install option. We also ha=
ve our data spread across storage mediums; fiber, nas. Do these things fact=
or in?2.) We also have to stand up a fresh in=
stall of pg 9.3 and restore the data from a 9.1.6 dump, do you recommended =
that you use the pg_dump or <span class=
=3D"APPLICATION">pg_dumpall?and since we have our data sp=
read across storage locations on fiber and nas, we will have to replicate t=
he file system structure on the target os to be identical to that of the so=
urce 9.1.6 dump file system?3.) In general if the=
 backup takes approximately 5-7 days, will the restore to the fresh install=
 environment take as long, or longer? Trying to gauge downtime requirements=
. thanks=0A<blockquote i=
d=3D"replyBlockquote" webmail=3D"1" style=3D"border-left: 2px solid blue; m=
argin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-famil=
y:verdana;">=0A=0A-------- Original Message ----=
----=0ASubject: Re: [GENERAL] Upgrading from postgreSQL 9.1.6 to 9.3<br=
>=0AFrom: Paul Ramsey <pram=
sey@cleverelephant.ca>=0ADate: Thu, September 19, 2013 10:51 am<=
br>=0ATo: fburgess@radiantblue.=
com=0ACc: pgsql-gen=
eral@postgresql.org=0A=0ARecommendation: do one at a time. Firs=
t postgis 1.5 to 2.1, then pg 9.1 to 9.3. =0AP.=0A=0A-- =0A=
Paul Ramsey=0Ahttp://cleverelephan=
t.ca=0Ahttp://postgis.net=0A=
=0A=0AOn Thursday, September 19, 2013 at 4:34 PM, <a href=3D"mailto=
:fburgess@radiantblue.com">fburgess@radiantblue.com wrote:=0A=
=0A> =0A> =0A> Are there any showstoppers/recommendations/=
experiences with upgrading from Postgres 9.1.6 Postgis 1.5.3 to PostGres 9.=
3 and associated PostGIS version XX on rhel 6.4 that will help the process =
go smoothly.=0A> =0A> =0A> =0A> thanks =0A<=
br>=0A=0A=0A=0A