rh-PostgreSQL 9.4 is EOL

(Stéphane de Labrusse) #1

The software collection rh-postgresql94 reached is end of life since april 2018, no more security updates, now we should build rh-postgresql95 or rh-postgresql96 for our needs ( mattermost is the first rpm I have in mind)

The mattermost documentation states for requirement PostgreSQL 9.4+, we could try PostgreSQL 9.6.

cc @giacomo @davidep

(Stéphane de Labrusse) #2

as a side note, rh-postgresql10 is probably the best target

(Matteo Valentini) #3

Hi @stephdl, I have checked and the only nethserver’s package that require PostgreSQL 9.4 is mattermost: https://github.com/search?q=org%3ANethServer+nethserver-postgresql94&type=Code

I will take a look for the best migration strategy.

(Stéphane de Labrusse) #4

I already forked postgresl10 on my repo, see the gh issue

(Matteo Valentini) #5

After some research, I think that we can replace postgres 9.4 with postgres 10, with this pro points:

For the migration strategy, i have done some tests with a simple dump&restore procedure without find evident problems/errors.

(Giacomo Sanchietti) #6

Let’s try to go down this path.

Let me know if any help is needed.