Open topic with navigation

Change the PostgreSQL Passwords

These steps describe how to change the PostgreSQL passwords using pgAdmin, although you can use any SQL query tool to perform this task.

Steps

1. Start pgAdmin.

2. Right-click on a database, and then select Query Tool.

   The workspace for the selected database appears.

3. In the workspace, enter ALTER statements for each role to be changed using the following format:

    ALTER ROLE username SET PASSWORD TO 'newpassword'

4. At the top of the workspace, select .

   The query runs and the password is changed.

   Note: For more information about the PostgreSQL roles, see the PostgreSQL documentation.

What's Next? 

• Refer to the first-time deployment workflow.

Copyright © 2018 General Electric Company. All rights reserved.