<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18294" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Ben,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Sorry about that. The upgrade section of the
docs does need sufficient revamp. But been putting it of since we've been
working on revamping this process.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>The short answer -- Hard upgrade really doesn't have
anything to do with PostgreSQL version upgrade. AS long as you have the
same version of PostGIS in your new install as you did in your old
install. Hard upgrade doesn't come into play.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>In the past -- it was kind of iffy when you needed to do a
Hard upgrade vs. a soft upgrade.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Moving forward -- a hard upgrade is only needed if you are
moving from major to major version (e.g. from a 1.3 -->
2.0)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Soft upgrade -- 1.3 ->1.4 , 1.3->1.5
etc.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>From 1.2 its kind of iffy -- you really should do a hard
upgrade (or manual massaging if you know what you are doing) since aggregate
functions don't carry over.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Hope that answers your question,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=308545500-14092009><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Ben
Madin<BR><B>Sent:</B> Sunday, September 13, 2009 6:23 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> [postgis-users] HARD or SOFT upgrade -
documentation questions.<BR></FONT><BR></DIV>
<DIV></DIV>And since I'm following the manual, two more questions:
<DIV><BR></DIV>
<DIV>1. Does hard / soft upgrades refer to changes in PostGIS, or changes in
PostgreSQL, or both? Having soft upgraded PostGIS from 1.3.6 to 1.4.0 I wonder
if it is more relevant to the PostgreSQL version number.</DIV>
<DIV><BR></DIV>
<DIV>2. In the manual, it has the following line :</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=Apple-style-span
style="FONT-SIZE: 14px; COLOR: rgb(46,46,46); FONT-FAMILY: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif">
<DIV class=titlepage>
<DIV>
<DIV>
<H3 class=title
style="FONT-SIZE: 16px; MARGIN-BOTTOM: 16px; COLOR: rgb(33,55,128); LINE-HEIGHT: 18px">2.7.2. Hard
upgrade</H3></DIV></DIV></DIV>
<P style="FONT-SIZE: 10pt">By HARD UPGRADE we intend full dump/reload of
postgis-enabled databases. You need an HARD UPGRADE when postgis objects'
internal storage changes or when SOFT UPGRADE is not possible. The <A
title=Appendix A. Appendix
style="COLOR: rgb(65,138,205); TEXT-DECORATION: none"
href="http://postgis.refractions.net/documentation/manual-1.4/release_notes.html">Release
Notes</A> appendix reports for each version whether you need a dump/reload
(HARD UPGRADE) to upgrade.</P>
<DIV><FONT class=Apple-style-span size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 13px"><BR></SPAN></FONT></DIV></SPAN></DIV>
<DIV>but in the Release Notes appendix I can't find anywhere any guidance on
whether I need a hard or soft upgrade. </DIV>
<DIV><BR>
<DIV>cheers</DIV>
<DIV><BR></DIV>
<DIV>Ben</DIV>
<DIV><BR></DIV>
<DIV><BR>
<DIV><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: medium Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">
<DIV><BR class=Apple-interchange-newline>-- </DIV>
<DIV><BR>Ben Madin<BR>REMOTE INFORMATION<BR><BR>t : +61 8 9192 5455<BR>f : +61 8
9192 5535<BR>m : 0448 887 220<BR>Broome WA
6725<BR><BR><A
href="mailto:ben@remoteinformation.com.au">ben@remoteinformation.com.au</A><BR><BR><BR><BR><SPAN
class=Apple-tab-span style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN>Out here, it pays to
know...<BR><BR></DIV></SPAN></DIV><BR></DIV></DIV></BODY></HTML>