Re: [GENERAL] Upgrading postgresql minor version

Поиск
Список
Период
Сортировка
От Ron Ben
Тема Re: [GENERAL] Upgrading postgresql minor version
Дата
Msg-id ~00259132E2E8F1A56000C4E@walla.co.il
обсуждение исходный текст
Ответ на [GENERAL] Upgrading postgresql minor version  (Ron Ben <ronb910@walla.co.il>)
Ответы Re: [GENERAL] Upgrading postgresql minor version  (Andreas Joseph Krogh <andreas@visena.com>)
Re: [GENERAL] Upgrading postgresql minor version  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Re: [GENERAL] Upgrading postgresql minor version  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: [GENERAL] Upgrading postgresql minor version
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: [GENERAL] Upgrading postgresql minor version