Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Upgrading postgresql minor version - Mailing list pgsql-general

From Ron Ben
Subject Re: [GENERAL] Upgrading postgresql minor version
Date
Msg-id ~00259132E2E8F1A56000C4E@walla.co.il
Whole thread Raw
In response to [GENERAL] Upgrading postgresql minor version  (Ron Ben <ronb910@walla.co.il>)
Responses Re: [GENERAL] Upgrading postgresql minor version
Re: [GENERAL] Upgrading postgresql minor version
Re: [GENERAL] Upgrading postgresql minor version
List pgsql-general
Tree view
Not possible 
https://www.postgresql.org/download/linux/debian/
 
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.
If not, the documntation is insuffecent. We all know that sometimes even the smallest change can cause troubles.

ב מאי 10, 2017 18:02, Andreas Joseph Krogh כתב:
På onsdag 10. mai 2017 kl. 16:55:50, skrev Ron Ben <ronb910@walla.co.il>:
 
I think you miss understood me.
pg_dump dumps the data. the tables, functions and the data saved in them.
I have daily backups for this so i'm not worried.
 
What i'm woried about are the "executables files". These files are what is actualy being updated when you update the version.
I want to be able to roll them back in case of upgrade failure without rolling back the data.
 
 
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.
Is it doable? How?
 
What about just re-installing the previous version the same way you installed the "patch-release"-version?

--
Andreas Joseph Krogh
 


pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: [GENERAL] Upgrading postgresql minor version
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: [GENERAL] Upgrading postgresql minor version