Set Up the External Databases

Set up the external databases for Private Cloud, with and without SSL.

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

  1. Install PostgreSQL 10.6 or greater.
  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, complete the following steps:

  1. Place a leaf certificate, and the certificate's private key on the postgres server.
  2. Set the ssl_cert_file parameter to the location of the leaf certificate. Set the postgresql.conf parameter to the location of the key files.
  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.