Thread: [GENERAL] Upgrading postgresql minor version

On 05/10/2017 06:08 AM, Ron Ben wrote:
> I'm about to upgrade my postgresql to the latest 9.3 version
> On my test server eveything works.
> However I want to save a backup of my production server before the
> upgrade...
> I'm not sure how I do that.

https://www.postgresql.org/docs/9.3/static/app-pg-dumpall.html

> It says that only system files are changed during upgrade... which
> folders exactly I need to save on the side for roll back?

I would say that would depend on the nature of the release changes.

> I know I can take a snap shoot of my server before the update but i'm
> affried that rolling back to this snap shoot will also roll back the
> data itself?
> Since after the update the users continue to work I don't want to lose
> thier data.

Well if the upgrade takes then you don't need to rollback. If it did not
then the users did not get any work done or any data they entered would
be considered suspect. If you are concerned then take another pg_dumpall
before rolling back.


> How do I do that?


--
Adrian Klaver
adrian.klaver@aklaver.com

On Wednesday, May 10, 2017 9:08:16 AM EDT Ron Ben wrote:
> ....

Ron,

You need to figure out how you can make your email client send something else
than base64 encoded HTML with right-aligned text. Your messages are so hard to
parse for me I just ignore them, and I assume there's other people that do the
same.

Attached a screenshot of one of your messages.

 

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?

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.

On Wednesday 10 May 2017 17:13:50 Ron Ben wrote:
> 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.
>

Download the old packages from the repository. You can use dpkg to manually
downgrade them if needed.  You can also use dpkg to get a list of the files in
any particular package if you want to save them manually.

Or you should ask your system administrator for help.

This is not a PostgreSQL issue and that's why it (and many other things) are
not in the docs. Every version of Linux uses a different package manager. The
system administrator needs to know how to use it.