20.1 Backing Up the PostgreSQL Database

As a precaution, you should always back up the PostgreSQL database that you use with Cloud Manager before you upgrade to a newer version of Cloud Manager.

For more information about backing up a PostgreSQL database, see the PostgreSQL documentation. The following specific instructions are helpful in this process:

  • If you chose to automatically configure the PostgreSQL database during the initial Cloud Manager installation, the PostgreSQL password is located in the /etc/opt/netiq/cloudmanager/etc/pgusr.in file.

  • If the PostgreSQL DBMS you are using has several databases, you can list the database names using the following command:

    sudo -u postgres psql -l
  • The Cloud Manager database name should contain the phrase cloudmanager. This is the database you want to back up.

  • When you identify the Cloud Manager database you want to back up, use a command similar to the following to back it up:

    sudo -u postgres pg_dump -s cloudmanager > /var/opt/netiq/cloudmanager/cm_database_backup.dump.out