On 25 December 2017 at 09:39, Benyamin Guedj <benyamin...@gmail.com> wrote: > > 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? >
clearly no, our versioning page says (https://www.postgresql.org/support/versioning/): """ The PostgreSQL project aims to fully support a major release for five years. After its end-of-life (EOL) month ends, a major version receives one final minor release. After that final minor release, bug fixing ceases for that major version. """ so, if bug fixing ceases for a non-supported version it's clearly no "best practice" to continue using it. so you have two options: 1) use the packages from yum.postgresql.org for a supported version 2) get commercial support for your out-of-community-support verssion but even if you do 2, that would be a preparatory step looking forward to upgrade to a newer version -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
