Cloudera Docs

Configure PostgreSQL as the backend database for Cloudera Data Explorer (Hue)

After installing and configuring the PostgreSQL database, you can configure Data Explorer to use it as its backend database.

  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > service and stop the Data Explorer service by clicking ACTIONS > Stop.
  3. Go to Clusters > service > Configuration > Category > Database.
    All the database configurations for Data Explorer are displayed.
  4. Select PostgreSQL as the Hue Database Type.
  5. Specify the fully qualified domain name (FQDN) of the host on which you have installed the PostgreSQL database in the Hue Database Hostname field.
  6. Enter 5432 in the Hue Database Port field.
  7. Enter user name and password in Hue Database Username and Hue Database Password fields.
  8. Specify the database name in the Hue Database Name field.
  9. Click Save Changes and restart the Hue service.
If the database setup is successful and starts without errors, then you should be able to log into the Data Explorer web interface and view the database and tables.