<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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-family: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif; color: rgb(46, 46, 46); font-size: 14px; "><div class="titlepage"><div><div><h3 class="title" style="color: rgb(33, 55, 128); font-size: 16px; line-height: 18px; margin-bottom: 16px; ">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 href="http://postgis.refractions.net/documentation/manual-1.4/release_notes.html" title="Appendix A. Appendix" style="text-decoration: none; color: rgb(65, 138, 205); ">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="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -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>