Question
Which version of postgres/pgsql should I install on my server?
Answer
cPanel only provides support for the version of postgres/pgsql that the /scripts/installpostgres script installs. This script installs the postgres version present in the server's operating-system repository.
Currently the versions provided by the operating-system's repositories are as follows.
CentOS 7 - PostgreSQL 9.2.24
CloudLinux 7 - PostgreSQL 9.2.24
AlmaLinux 8 - PostgreSQL 9.6.22
CloudLinux 8 - PostgreSQL 9.6.22
Ubuntu 20.04 LTS - Not supported at this time*
You can read more about how to install postgres here: