Hello,
The company I’m working for develops a product which uses Centos 6/7 (different versions of the product) and also uses Vertica and PostgreSQL.
During the course of the development of the latest version of our product, we ran into problems that lead us to contact Vertica’s R&D team, which in turn suggested we upgrade our database to the latest version as the current one is not supported.
When the product was first developed we used PostgreSQL 9.2, and after upgrading to Centos 7 we considered upgrading our PostgreSQL version as well.
Trying to learn from the aforementioned incident, we floated idea of upgrading our PostgreSQL version to the latest one in order to get the performance improvement, latest features, bug fixes and support.
Upon doing so, our DevOps team in response insisted (and still insists) that we keep using version 9.2 as it is part of the Centos 7 distribution, and they believe that version to be “best practice”, even though PostgreSQL 9.2 is no longer supported.
My question is:
Is working with the default distribution’s version (9.2) really the “best practice”, even though it is no longer supported?
I have looked for documentation regarding the matter but could not find any answers. I would greatly appreciate your assistance with the matter.
Thanks in advance,
Benjamin