Re: How to upgrade PostgreSQL minor version?

On Wed, Apr 26, 2017 at 4:41 PM Ron Ben <ronb910(at)walla(dot)co(dot)il> wrote:

> I'm runing PostgreSQL 9.3.3 and I want to upgrade it to the latest 9.3
> version
> The documontation does not specify what needs to be done other than "just
> install the executables".
> This is wierd as for example 9.3.5 release notes request to run a specifc
> query to check for pg_multixact files left.
>
> I saw this question:
>
> https://serverfault.com/questions/563667/update-9-3-x-minor-verison-of-postgres-on-ubuntu-12-04
> I'm not sure how this will handle the 9.3.5 check issue.
>
>

What is the version of PostgreSQL that you are running?

Though there are some general guidelines/procedure (which is as simple as
stop the server, upgrade binaries and start, there will also be some
peculiar releases which has a bug-fix. While the bug-fix covers you in
future, there might have been incidents where you are already bitten by bug
being fixed (worse if you have not yet identified it). To cover such cases,
you would need to follow some custom procedure. Again, mostly the custom
steps are not for patch application but more of a mitigation against risks
of bug or in some cases bug-fix.

Are you running with a standby or just stand-alone setup?

Is it really just runing one command?
> What if there are errors and problems? how do i revert back?
> Sadly there is not enough information regarding minor verion updates...
>
> I'm also runing ubuntu server 12 which will be updated as well later this
> quarter.
>

Do you have a test environment? If I were you I would have a non-prod that
mimics my production setup exactly and I would apply the patch there first.

--

--

Best Regards,

*Sameer Kumar | Senior Solution Architect*

*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

T: +65 6438 3504 | www.ashnik.com

Skype: sameer.ashnik | M: +65 8110 0350