Changing the PostgreSQL Database Password


When you perform database Backup and Recovery operations or configure Configure CCM Wizard Properties in non-HA mode, or in standalone or HA modes, you may encounter situations where you need to use the database credentials.

The CCM server uses the cliqr account to connect to the database, the password for this account is also read from the configuration file. While the database username is hardcoded as cliqr and cannot be changed, you can change the database password (cliqr). Be sure to actually change the PostgresDB password for this cliqr user, and also update the file to reflect the correct password


To change the default password for the PostgreSQL database (cliqrdb) from cliqr to a password of your choice, follow this procedure.

If you change the default database password, remember to use the changed password in place of the default cliqr password provided in the documentation.

  1. Log into the database server using the default credentials:
    • Username: cliqr
    • Password: cliqr
  2. Change the PostgreSQL database password using the following commands:

    psql -U cliqr
    psql -U cliqr -d cliqrdb
    alter user "cliqr" WITH PASSWORD '<new_password>';
  3. Log out and login again using the new password.
  4. Remember to use the new PostgreSQL database password when you see the cliqr password in documentation.

  • No labels