Search Postgresql Archives

Re: Upgrading postgresql minor version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 10, 2017 at 8:13 AM, Ron Ben <ronb910@xxxxxxxxxxx> wrote:
Not possible 
 
To upgrade I do: apt-get install postgresql-9.3
There is no way to "roll back" from here.
I can not choose which version to install, it install the latest version packed for debian. Currently its 9.3.16
 
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.
 
​I see that the binaries involved are located under "/usr/​lib/postgresql" - in directories matching up with the version-cluster naming scheme the the apt packages employ.  In theory backing up and restoring the relevant directories under there should work.  This would only work for minor version switching.

If not, the documntation is insuffecent. We all know that sometimes even the smallest change can cause troubles.

​Maybe, but as noted its not the PostgreSQL project's ​documentation that is lacking here - since you are not installing from source.

I've never seen whether the upgrade process touches any other files, or exactly what it touches for that matter, but that should should be enough info to experiment.  It would be interesting to use Docker (or an equivalent) and perform an update and see what what the new layer shows as having been changed.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux