IBM Security Identity Governance and Intelligence, Version 5.2.3

Changing the Postgres database password

For security reasons, you might want to change the Postgres database password from the default password.

About this task

You can change the password of the Postgres administrator and the password for the database schema users. The Postgres database passwords can be changed from the primary node only.

Procedure

  1. From the top-level menu of the Appliance Dashboard, click Configure > Postgres Management.
  2. Select the database to activate the management functions.
  3. Click Manage > Database > Change Password.
  4. Select the type of user that you want to change the password for from the Users menu.
    DB Admin
    Is the Postgres database administrator, whose ID is postgres. Initially, the password is by default set to the same value of the password of the administrator of the virtual appliance. After the first time that the database administrator password is changed, the two administrator passwords follow different paths.
    DB Users
    Are the Postgres database schema users.
    Note: Changing this password, changes the password for all database schema users.
  5. Type the current password for the specified user type in the Current password field. If you upgraded from version 5.2.1, the default Postgres database password is postgres.
  6. Type the new password for the selected user type.
  7. Type the password again to confirm it.
  8. Click Save Configuration.

    A message indicates that the Postgres password is being changed. A system notification message is displayed that the Postgres password was changed successfully.