You can change the default DataWarehouse password (whuserservice) for the Postgres historical reporting database.
Note:
If the password policy is enabled, it is applied on DataWarehouse password, then you must to reset the password as per your choice.
Log in to the Cluster Control Manager (CCM) console as the customer user.
Switch to being the root user by entering the command su.
To run the Analytics Administration script, use the following command:
ADDITIONAL INFORMATION:
ccm release orca analytics
Select Historical Reporting by pressing the corresponding number.
Select Historical Reporting Configuration by pressing the corresponding number.
Select the Configure DataWarehouse Password for Historical Reporting option by entering the corresponding number.
In the Proceed with DataWarehouse password config? option, type y or n.
ADDITIONAL INFORMATION:
Typing n cancels the operation.
STEP RESULT:
When you type y, CCM displays a prompt to enter the credentials to the DataWarehouse database.
Enter the DataWarehouse database password.
Enter and confirm the new password.
ADDITIONAL INFORMATION:
Note:
When the DataWarehouse password is changed, it invalidates all the backups taken with the old password. Therefore, ensure that you take a full backup of the Postgres historical reporting database immediately after changing the password.
STEP RESULT:
The DataWarehouse (whuserservice) password is changed. The mstr-srv pod is restarted. Historical reporting is restarted.
