Download and install PostgreSQL

RHEL and CentOS 7 include PostgreSQL version 9.2. However, on these OS versions, Hue is compatible only with PostgreSQL versions 10, 11.x, 12, 13 and 14. Therefore, you must download and install the PostgreSQL distribution separately.

For supported PostgreSQL versions and compatibility information, see https://supportmatrix.cloudera.com/.

You must have root privileges or sudo access.
  1. Download the PostgreSQL distribution from https://www.postgresql.org/download/ based on your OS version.
  2. SSH into the host on which you want to install the PostgreSQL database:
  3. Install the PostgreSQL server using the following command:
    sudo yum install postgresql-server
    (For PostgreSQL 16 on Ubuntu 22 - (CDP 7.1.9 SP1 and higher)):
    sudo apt -y install postgresql-16
    (For PostgreSQL 16 on RHEL 9 - (CDP 7.1.9 SP1 and higher)):
    sudo dnf install -y postgresql16-server