Changing Embedded PostgreSQL Database Passwords

The embedded PostgreSQL database has generated user accounts and passwords. You can change a password associated PostgreSQL database account.

You can see the generated accounts and passwords during the installation process and you should record them at that time.
To find information about the PostgreSQL database account that the Cloudera Manager Server 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 change a password associated with a PostgreSQL database account:

  1. Obtain the root password from 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.
  2. On the host on which the Cloudera Manager Server is running, log into PostgreSQL as the root user:
    psql -U cloudera-scm -p 7432 -h localhost -d postgres
    Password for user cloudera-scm: MnPwGeWaip
    psql (8.4.18)
    Type "help" for help.
  3. Determine the database and owner names:
    postgres=# \l
                                             List of databases
       Name    |    Owner     | Encoding | Collation  |   Ctype    |         Access privileges         
     amon      | amon         | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     hive      | hive         | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     nav       | nav          | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     navms     | navms        | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     postgres  | cloudera-scm | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     rman      | rman         | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     scm       | scm          | UTF8     | en_US.UTF8 | en_US.UTF8 | 
     template0 | cloudera-scm | UTF8     | en_US.UTF8 | en_US.UTF8 | =c/"cloudera-scm"
                                                                   : "cloudera-scm"=CTc/"cloudera-scm"
     template1 | cloudera-scm | UTF8     | en_US.UTF8 | en_US.UTF8 | =c/"cloudera-scm"
                                                                   : "cloudera-scm"=CTc/"cloudera-scm"
    (9 rows)
  4. Set the password for an owner using the \password command. For example, to set the password for the amon owner, do the following:
    postgres=# \password amon
    Enter new password: 
    Enter it again: 
  5. Configure the role with the new password:
    1. In the Cloudera Manager Admin Console, select Clusters > Cloudera Management Service.
    2. Click the Configuration tab.
    3. In the Scope section, select the role where you are configuring the database.
    4. Select Category > Database category.
    5. Set the Role Name Database Password property.
    6. Enter a Reason for change, and then click Save Changes to commit the changes.