Backing Up Databases In Cloudera

 Cloudera recommends that you schedule regular backups of the databases that Cloudera Manager uses to store configuration, monitoring, and reporting data and for managed services that require a database

Cloudera Manager Server - Contains all the information about services you have configured and their role assignments, all configuration history, commands, users, and running processes. This relatively small database (< 100 MB) is the most important to back up

To back up a PostgreSQL database, use the same procedure whether the database is embedded or external:

Step 1: Start

Step 2: Log in to the host where the Cloudera Manager Server is installed

Step 3:  Get the name, user, and password properties for the Cloudera Manager database from /etc/cloudera-scm-server/db.properties

com.cloudera.cmf.db.name=scm

com.cloudera.cmf.db.user=scm

com.cloudera.cmf.db.password=NnYfWIjlbk

Step 4: Run the following command as root using the parameters from the preceding step

 pg_dump -h hostname -p 7432 -U scm > /tmp/scm_server_db_backup.$(date +%Y%m%d)

Step 5: Enter the password from the com.cloudera.cmf.db.password property in step 2

Step 6: Stop