This is the documentation for Cloudera 5.2.x.
Documentation for other versions is available at Cloudera Documentation.

Embedded PostgreSQL Database

Continue reading:

Installing and Starting the Embedded PostgreSQL Database

This procedure should be used only when creating a demonstration or proof-of-concept deployment. It is not recommended for production.

If you are using Installation Path B - Manual Installation Using Cloudera Manager Packages and you want to use an embedded PostgreSQL database for the Cloudera Management Server, use this procedure to install and start the database:
  1. Install the embedded PostgreSQL database packages:
    OS Command
    Red Hat-compatible, if you have a yum repo configured
    $ sudo yum install cloudera-manager-server-db-2
    Red Hat-compatible, if you're transferring RPMs manually
    sudo yum --nogpgcheck localinstall cloudera-manager-server-db-2.noarch.rpm
    $ sudo zypper install cloudera-manager-server-db-2
    Ubuntu or Debian
    $ sudo apt-get install cloudera-manager-server-db-2
  2. Start the PostgreSQL database:
    $ sudo service cloudera-scm-server-db start

Stopping the Embedded PostgreSQL Database

  1. Stop the services that have a dependency on the Hive Metastore (Hue, Impala, and Hive) in the following order:
    • Stop the Hue and Impala services.
    • Stop the Hive service.
  2. Stop the Cloudera Management Service.
  3. Stop the Cloudera Manager Server.
  4. Stop the Cloudera Manager Server database:
    sudo service cloudera-scm-server-db stop

Changing Embedded PostgreSQL Database Passwords

The embedded PostgreSQL database has predefined user accounts and passwords. To change passwords associated with the embedded PostgreSQL database accounts, retrieve the user name or password, as well as other database information as follows.

To find information about the PostgreSQL database user account that the Cloudera Manager uses, read the /etc/cloudera-scm-server/ file:
# cat /etc/cloudera-scm-server/

Auto-generated by
Sat Oct 1 12:19:15 PDT 201
To find information about the root account for the database, read the /var/lib/cloudera-scm-server-db/data/generated_password.txt file:
# cat /var/lib/cloudera-scm-server-db/data/generated_password.txt


The password above was generated by /usr/share/cmf/bin/ (part of the cloudera-scm-server-db package)
and is the password for the user 'cloudera-scm' for the database in the current directory.

Generated at Fri Jun 29 16:25:43 PDT 2012.

Once you have the passwords, you can change them for users if desired.