1.) We have to upgrade four 9.1 database instances, so is using pg_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 have our data spread across storage mediums; fiber, nas. Do these things factor in?

2.) We also have to stand up a fresh install of pg 9.3 and restore the data from a 9.1.6 dump, do you recommended that you use the pg_dump or pg_dumpall?

and since we have our data spread across storage locations on fiber and nas, we will have to replicate the file system structure on the target os to be identical to that of the source 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

-------- Original Message --------
Subject: Re: [GENERAL] Upgrading from postgreSQL 9.1.6 to 9.3
From: Paul Ramsey <pramsey@cleverelephant.ca>
Date: Thu, September 19, 2013 10:51 am
To: fburgess@radiantblue.com
Cc: pgsql-general@postgresql.org

Recommendation: do one at a time. First postgis 1.5 to 2.1, then pg 9.1 to 9.3.
P.

--
Paul Ramsey
http://cleverelephant.ca
http://postgis.net

On Thursday, September 19, 2013 at 4:34 PM, fburgess@radiantblue.com wrote:

>
>
> 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.
>
>
>
> thanks