<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>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?<br></div><div><br></div><div>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 <span class="APPLICATION">pg_dump</span> or <span class="APPLICATION">pg_dumpall</span>?</div><div>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?</div><div><br></div><div>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. <br></div><div><br></div><div>thanks</div><div><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [GENERAL] Upgrading from postgreSQL 9.1.6 to 9.3<br>
From: Paul Ramsey <<a href="mailto:pramsey(at)cleverelephant(dot)ca">pramsey(at)cleverelephant(dot)ca</a>><br>
Date: Thu, September 19, 2013 10:51 am<br>
To: <a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a><br>
Cc: <a href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a><br>
<br>
Recommendation: do one at a time. First postgis 1.5 to 2.1, then pg 9.1 to 9.3. <br>
P.<br>
<br>
-- <br>
Paul Ramsey<br>
<a href="http://cleverelephant.ca">http://cleverelephant.ca</a><br>
<a href="http://postgis.net">http://postgis.net</a><br>
<br>
<br>
On Thursday, September 19, 2013 at 4:34 PM, <a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a> wrote:<br>
<br>
> <br>
> <br>
> 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.<br>
> <br>
> <br>
> <br>
> thanks <br>
<br>
<br>
</div>
</blockquote></span></body></html>