Which version to upgrade upto
Hi All,
We are using postgres 9.5.9 in streaming replication with repmgr. The
project is now considering to update postgreSQL instances to latest
versions.
I am looking for which version to upgrade to. I can see the current version
in postgres 11 is 11.4, and 10.9 in 10.
How to decide on which version we should use?
Should I go for 10.9 or 11.2? The architects are suggesting 11.2
Please advise.
Regards
Vikas
On Wed, Jul 31, 2019 at 4:55 PM Vikas Sharma <shavikas@gmail.com> wrote:
Should I go for 10.9 or 11.2? The architects are suggesting 11.2
Moving fom 9.5 requires in any case a major version upgrade, therefore
I would go for the latest one, 11.4.
Are there any particular needs that feed your doubts about the version?
Luca
The architects and developers have perception that the latest release
always will have bugs and others might be using in production. They feel
11.2 will be better bet than 11.4.
On Wed, Jul 31, 2019, 16:24 Luca Ferrari <fluca1978@gmail.com> wrote:
Show quoted text
On Wed, Jul 31, 2019 at 4:55 PM Vikas Sharma <shavikas@gmail.com> wrote:
Should I go for 10.9 or 11.2? The architects are suggesting 11.2
Moving fom 9.5 requires in any case a major version upgrade, therefore
I would go for the latest one, 11.4.
Are there any particular needs that feed your doubts about the version?Luca
On 7/31/19 9:57 AM, Vikas Sharma wrote:
The architects and developers have perception that the latest release
always will have bugs and others might be using in production. They
feel 11.2 will be better bet than 11.4.
Except of course for the bugs fixed in .3 and .4.
On Wed, Jul 31, 2019 at 8:58 AM Vikas Sharma <shavikas@gmail.com> wrote:
The architects and developers have perception that the latest release
always will have bugs and others might be using in production. They feel
11.2 will be better bet than 11.4.
Beginning with version 10 the second position in the version number became
the patch release version so both 11.2 and 11.4 are the same major version
(v11) and 11.2 is guaranteed to be more buggy than 11.4. If you wish to be
cautious then you should upgrade to the v10 series which is presently at
10.9
David J.
Vikas Sharma schrieb am 31.07.2019 um 17:57:
The architects and developers have perception that the latest release
always will have bugs and others might be using in production. They
feel 11.2 will be better bet than 11.4.
You should always use the latest minor version, so 11.4 is preferred over 11.2
Quote from the homepage[1]https://www.postgresql.org/support/versioning/
For minor releases, the community considers not upgrading to be riskier than upgrading
So definitely go with 11.4
If you want to see how many (and which) bugs have been fixed between 11.2 and 11.4 you can check:
https://why-upgrade.depesz.com/show?from=11.2&to=11.4&keywords=
Thomas
Vikas Sharma <shavikas@gmail.com> writes:
The architects and developers have perception that the latest release
always will have bugs and others might be using in production. They feel
11.2 will be better bet than 11.4.
Your architects are apparently completely unfamiliar with Postgres.
Tell them to read
https://www.postgresql.org/support/versioning/
particularly the bit about
While upgrading will always contain some level of risk, PostgreSQL
minor releases fix only frequently-encountered bugs, security issues,
and data corruption problems to reduce the risk associated with
upgrading. For minor releases, the community considers not upgrading
to be riskier than upgrading.
It is true that we've sometimes accidentally introduced regressions
into minor releases --- we're all mortal. But to focus on that case
and ignore all the genuine bug fixes in each minor release is flat out
folly.
regards, tom lane