Set up the external databases

You must set up the external databases to be used with CDP Private Cloud Experiences Experiences. You must enable the base cluster PostgreSQL database to use an SSL connection to encrypt client-server communication as a requirement for Cloudera Data Warehouse (CDW) experience.

To set up the external databases for Private Cloud, complete the following steps:

  1. Install PostgreSQL 10.6 or higher.
  2. In the postgresql.conf file, set the following parameters:
    • parameters listen_addresses = '*'
    • max_connections = 1000
  3. In the pg_hba.conf file, add the following lines:
    host all all 0.0.0.0/0 md5
    host all all ::/0 md5
  4. Restart the Postgres server.
  5. Create the databases and database user that were used during the Control Plane installation.

To enable SSL, which is a requirement for CDW, complete the following steps:

  1. Place a leaf certificate, and the certificate's private key on the Postgres server.
  2. In the postgresql.conf file, set the following parameters
    • Set the ssl_cert_file parameter to the location of the leaf certificate.
    • Set the ssl_key_file parameter to the location of the key file.
  3. Set ssl=on in the postgresql.conf file.
  4. In the postgresql.conf file, set the following parameters:
    • parameters listen_addresses = '*'
    • max_connections = 1000
  5. In the pg_hba.conf file, add the following lines:
    host all all 0.0.0.0/0 md5
    host all all ::/0 md5
  6. Restart the Postgres server.
  7. When you are prompted, upload the CA that signed the leaf certificate, to the Cloudera Manager UI.
  8. Create the databases and database user that were used during the Control Plane installation.