Upgrading from postgreSQL 9.1.6 to 9.3

Started by Burgess, Freddieover 12 years ago3 messagesgeneral

FBurgess@Radiantblue.com

over 12 years ago

<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div></div><div>

<p class="MsoNormal">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.</div><div class="MsoNormal" style="font-size:12pt;"><br></div><div class="MsoNormal" style="font-size:12pt;">thanks<br></div>

</p></span></body></html>

Paul Ramsey

pramsey@cleverelephant.ca

over 12 years ago

In reply to: Burgess, Freddie (#1)

Re: Upgrading from postgreSQL 9.1.6 to 9.3

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Burgess, Freddie

FBurgess@Radiantblue.com

over 12 years ago

In reply to: Paul Ramsey (#2)

Re: Upgrading from postgreSQL 9.1.6 to 9.3

<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@cleverelephant.ca">pramsey@cleverelephant.ca</a>><br>
Date: Thu, September 19, 2013 10:51 am<br>
To: <a href="mailto:fburgess@radiantblue.com">fburgess@radiantblue.com</a><br>
Cc: <a href="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.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@radiantblue.com">fburgess@radiantblue.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>

Import Notes

Resolved by subject fallback