Re: How to Works with Centos

On 25 December 2017 at 09:39, Benyamin Guedj <benyamin621@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

https://wiki.centos.org/AdditionalResources/Repositories/SCL
http://mirror.centos.org/centos/7/sclo/x86_64/rh/rh-postgresql96/

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