Supporting a PostgreSQL version newer than 10 years old

Operating System & Version
Centos 7.9
cPanel & WHM Version
96.0.9

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,497
1,968
363
cPanel Access Level
Root Administrator
Hey there! The page at PostgreSQL: Linux downloads (Red Hat family) is specifically using the PostGres repositories and not the CentOS repositories. So far, cPanel has only included support for the version of PostGres that is available directly from the operating system.

The official CentOS 7 repos still show version 9.2 as the latest supported version, so that's what we use:


There's some additional details from Lauren on the feature request here that you may also want to read: Improved PostgreSQL support
 

liebn0r

Well-Known Member
Dec 7, 2017
48
7
8
USA
cPanel Access Level
Website Owner
Considering WHM doesn't seem to have extensive functionality when it comes to PostgreSQL anyway, is it safe to remove the WHM version and install and maintain a modern PostgreSQL version independently / outside of the cPanel installer? There is only 1 account on the server and we just want to be able to run PostgreSQL with PostGIS for our own application.
 

andrew.n

Well-Known Member
Jun 9, 2020
930
345
63
EU
cPanel Access Level
Root Administrator
I believe - though I haven't tested - that cPanel will seamlessly work with newer versions since as far as I know no major changes were introduced in 9.6 for example.
 

garbintecnologia

Active Member
Mar 4, 2021
33
2
8
Brasil
cPanel Access Level
Root Administrator

garbintecnologia

Active Member
Mar 4, 2021
33
2
8
Brasil
cPanel Access Level
Root Administrator
Thanks for answering. In my case, I have some websites that use PostgreSQL, but above version 11, I thought maybe installing a newer version of PostgreSQL alone on the server, I don't know to what extent this can interfere with the functioning of WHM. Or, as a last resort, migrate everything to MariaDB (which would also work).
 

Kerrya

Member
Jul 27, 2013
20
1
53
cPanel Access Level
Reseller Owner
Hey there! The page at PostgreSQL: Linux downloads (Red Hat family) is specifically using the PostGres repositories and not the CentOS repositories. So far, cPanel has only included support for the version of PostGres that is available directly from the operating system.

The official CentOS 7 repos still show version 9.2 as the latest supported version, so that's what we use:
A bit confused here as I understand it cPanel supports AlmaLinux 8 which does come with Postgres versions up to 13. Does that not imply support for it?

V9 was EOL some time ago

Kerry