<div dir='rtl'><div>
<div dir="rtl">
<div dir="ltr">Hi :)<br /><br /></div>
<div dir="ltr">I do have a test enviroment and I will test eveything there first but I had cases where eveything worked on test but on production I had difficultes. It's rare but can happen.</div>
<div dir="ltr">Problems with upgrading PostgreSQL isn't like upgrading a package which effects few functions.</div>
<div dir="ltr">Since the documntation says just replace the executables I'm lost...</div>
<div dir="ltr">I notced that 9.3.5 and 9.3.9 requires sepcific test. Further more it says secificly not to perform the tests for 9.3.9 with versions piror to 9.3.5 as it might not work : "The lingering effects of a previously-fixed bug in pg_upgrade could also cause such a failure, in installations that had used pg_upgrade versions between 9.3.0 and 9.3.4." So this means I have to upgrade to 9.3.5 and only then to 9.3.16</div>
<div dir="ltr">How do I perform upgrade in steps to specific versions?</div>
<div dir="ltr"> </div>
<div dir="ltr">I'm runing 9.3.3 in production server and in test server.</div>
<div dir="ltr">Operating system is Ubuntu server 12</div>
<div dir="ltr"> </div>
<div dir="ltr">I'm still not sure that I can upgrade directly from 9.3.3 to 9.3.16 - The documntation always tells to "if you are upgrading from version earlier than 9.3.X check 9.3.X-1". It assums that everyone upgrading once the version was released which is not always the case. And as mentioned earlier 9.3.5 and 9.3.9 can create problems as they require specific checks.</div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
<div dir="ltr">I'd appriciate any insight.</div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
</div>
<section></section>
<blockquote style="margin: 0; margin-bottom: 20px; border-top: 1px solid #e0e0e0;"><br /> 26, 2017 13:26, Sameer Kumar :
<blockquote style="margin: 0; margin-bottom: 20px; border-top: 1px solid #e0e0e0;">
<div dir="ltr"><br /><br />
<div>
<div dir="ltr">On Wed, Apr 26, 2017 at 4:41 PM Ron Ben <<a href="mailto:ronb910(at)walla(dot)co(dot)il">ronb910(at)walla(dot)co(dot)il</a>> wrote:</div>
<blockquote style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">
<div dir="rtl">
<div>I'm runing PostgreSQL 9.3.3 and I want to upgrade it to the latest 9.3 version</div>
<div>The documontation does not specify what needs to be done other than "just install the executables".</div>
<div>This is wierd as for example 9.3.5 release notes request to run a specifc query to check for <tt>pg_multixact</tt> files left.</div>
<div> </div>
<div>I saw this question:</div>
<div><a href="https://serverfault.com/questions/563667/update-9-3-x-minor-verison-of-postgres-on-ubuntu-12-04" target="_blank">https://serverfault.com/questions/563667/update-9-3-x-minor-verison-of-postgres-on-ubuntu-12-04</a></div>
<div>I'm not sure how this will handle the 9.3.5 check issue.</div>
<div> </div>
<div> </div>
</div>
</blockquote>
<div> </div>
<div>What is the version of PostgreSQL that you are running?</div>
<div> </div>
<div>Though there are some general guidelines/procedure (which is as simple as stop the server, upgrade binaries and start, there will also be some peculiar releases which has a bug-fix. While the bug-fix covers you in future, there might have been incidents where you are already bitten by bug being fixed (worse if you have not yet identified it). To cover such cases, you would need to follow some custom procedure. Again, mostly the custom steps are not for patch application but more of a mitigation against risks of bug or in some cases bug-fix.</div>
<div> </div>
<div>Are you running with a standby or just stand-alone setup?</div>
<div> </div>
<div> </div>
<blockquote style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">
<div dir="rtl">
<div>Is it really just runing one command?</div>
<div>What if there are errors and problems? how do i revert back?</div>
<div>Sadly there is not enough information regarding minor verion updates...</div>
<div> </div>
<div>I'm also runing ubuntu server 12 which will be updated as well later this quarter.</div>
</div>
</blockquote>
<div> </div>
<div>Do you have a test environment? If I were you I would have a non-prod that mimics my production setup exactly and I would apply the patch there first. </div>
<div> </div>
</div>
</div>
<div dir="ltr">-- </div>
<div data-smartmail="gmail_signature">
<div dir="ltr">
<p><a style="font-family: arial,helvetica,sans-serif;"><span style="color: #212121; font-family: 'helvetica neue',helvetica,arial,sans-serif; line-height: 19.5px;">-- </span><br style="color: #212121; font-family: 'helvetica neue',helvetica,arial,sans-serif; line-height: 19.5px;" /></a></p>
<div style="font-family: 'helvetica neue',helvetica,arial,sans-serif; line-height: 19.5px;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p style="margin: 0cm 0cm 0pt;"><a><span style="color: #1e46b8;"><font size="2" face="Calibri">Best Regards,</font></span></a></p>
<p style="margin: 0cm 0cm 0pt;"><strong><span style="color: #2e74b5;"><font face="Calibri"><font size="2"><span style="background-color: rgba(251,246,167,0.498039);">Sameer Kumar</span> | Senior Solution Architect</font></font></span></strong></p>
<p style="margin: 0cm 0cm 0pt;"><font face="Calibri"><font size="2"><strong><span style="color: #00b050;">ASHNIK PTE. LTD.</span></strong></font></font></p>
<p style="margin: 0cm 0cm 0pt;"><span style="color: #1e46b8;"><font face="Calibri"><font size="2">101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533</font></font></span></p>
<p style="margin: 0cm 0cm 0pt;"><span style="color: #1e46b8;"><font size="2" face="Calibri">T: +65 6438 3504 | </font></span><font face="Calibri"><font size="2"><span style="color: #1e46b8;"><a href="http://www.ashnik.com/" target="_blank">www.ashnik.com</a></span></font></font></p>
<p style="margin: 0cm 0cm 0pt;"><span style="color: #1e46b8; font-family: calibri; font-size: small;">Skype:</span><span style="color: #1e46b8; font-family: calibri; font-size: small;"> <span style="background-color: rgba(251,246,167,0.498039);">sameer.ashnik</span></span><span style="color: #1e46b8; font-family: calibri; font-size: small;"> | </span> <span style="color: #1e46b8; font-family: calibri; font-size: small;">M: +65 8110 0350</span><font face="Calibri"><font size="2"><br /></font></font></p>
<p style="margin: 0cm 0cm 0pt;"><img src="https://www.ashnik.com/wp-content/uploads/2017/03/Final-Email-Signature.jpg" alt="" /></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</blockquote>
</div></div>
