Resetting postgres Password on the database

Last Updated : Dec 13, 2022 |
Prolog information
Metadata
Keywords:
Use this procedure to reset postgres password on historical reporting database.
  1. Log in to the Cluster Control Manager (CCM) console as a cust user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:
    ADDITIONAL INFORMATION:
    ccm release orca analytics
  4. Select Troubleshooting by pressing the corresponding number.
  5. Select General by pressing the corresponding number.
  6. To select the Change Programmatic Account Password option, enter the corresponding number.
  7. To reset the postgres password, select the Reset postgres Password on the Database option, enter the corresponding number.
  8. In the Continue with changing password? option, enter y.
  9. In the Enter current postgres Password option, enter your current postgres password.
  10. In the Enter new postgres Password option, enter a new password of your choice.
    STEP RESULT:
    The postgres password is changed. The mstr-web pod is restarted.
  11. Return to the previous page by entering b.
  12. Quit the current page by entering q.
  13. Return to the main menu by entering m.