Which version of postgres/pgsql should I install on my server?

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:

Install or Update PostgreSQL® on Your cPanel & WHM Server