Re: [GENERAL] How to upgrade PostgreSQL minor version? - Mailing list pgsql-general
On Wed, Apr 26, 2017 at 4:41 PM Ron Ben <ronb910@walla.co.il> wrote:
I'm runing PostgreSQL 9.3.3 and I want to upgrade it to the latest 9.3 versionThe 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: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.
--
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
pgsql-general by date: