The postgres user account is changed automatically in the script execution. However, you need to manually change any additional postgres user accounts using the existing SetDbPassword.sh script.
In Avaya Experience Portal, there can be several postgres database accounts used during the operation of the solution. Database user accounts are either created by the installer, which prompts for passwords, or through scripts. For any database user account, the password can be reset using the SetDbPassword.sh script.
However, some of these accounts are not created by default. These accounts can be created based on the needs of the specific customer. The customer should be aware of the creation of these accounts and their passwords. For details on the various accounts that exist and their relevance to a deployment, see Configuring the PostgreSQL database user accounts.
Note:
It is necessary to change the passwords of existing accounts. Since a change has been made to the configuration files, existing users and their passwords will have to be regenerated so that they are hashed into the newly selected algorithm. Failure to change the password of existing accounts may result in loss of functionality.
