Re: Upgrading postgresql minor version

<div><div dir="rtl"><div dir="ltr">Not possible&nbsp;</div>
<div dir="ltr">https://www.postgresql.org/download/linux/debian/</div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">To upgrade I do:&nbsp;apt-get install postgresql-9.3</div>
<div dir="ltr">There is no way to "roll back" from here.</div>
<div dir="ltr">I can not choose which version to install, it install the latest version packed for debian. Currently its 9.3.16</div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">The docuntation says that upgrading minor version is just "replacing the executables", so there has to be a way to save them on the side for roll back.</div>
<div dir="ltr">If not, the documntation is insuffecent. We all know that sometimes even the smallest change can cause troubles.</div></div><section class="cust_msg_end"></section><blockquote style="margin:0;margin-bottom:20px;border-top:1px solid #e0e0e0;"><br>ב מאי 10, 2017 18:02, Andreas Joseph Krogh כתב:<blockquote style="margin:0;margin-bottom:20px;border-top:1px solid #e0e0e0"><div>På onsdag 10. mai 2017 kl. 16:55:50, skrev Ron Ben &lt;<a href="mailto:ronb910(at)walla(dot)co(dot)il">ronb910(at)walla(dot)co(dot)il</a>&gt;:</div>

<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="rtl">
<div>&nbsp;
<div style="direction: ltr;">I think you miss understood me.</div>

<div style="direction: ltr;">pg_dump dumps the data. the tables, functions and the data saved in them.</div>

<div style="direction: ltr;">I have daily backups for this so i'm not worried.</div>

<div style="direction: ltr;">&nbsp;</div>

<div style="direction: ltr;">What i'm woried about are the "executables files". These files are what is actualy being updated when you update the version.</div>

<div style="direction: ltr;">I want to be able to roll them back in case of upgrade failure <u>without rolling back the data</u>.</div>

<div style="direction: ltr;">&nbsp;</div>

<div style="direction: ltr;">&nbsp;</div>

<div style="direction: ltr;">Basicly what I want is to save on the side all the files that will be change by the update and in case of failure just to replace them back.</div>

<div style="direction: ltr;">Is it doable? How?</div>
</div>
</div>
</div>
</blockquote>

<div>&nbsp;</div>

<div>What about just re-installing the previous version the same way you installed the "patch-release"-version?</div>

<div><br>
--<br>
Andreas Joseph Krogh</div>

<div>
<div>
<div>&nbsp;</div>
</div>
</div>
<br></blockquote></blockquote><br></div>