Here are a two methods of changing the PostgreSQL password in a Harmony environment. Method 1 is the most direct.
Method 1
- Launch PGAdmin
- Click File and select Add Server.
- Enter a name for the connection.
- Change the username from ‘postgres’ to ‘jitterbit’.
- Populate the password found in the [DbInfo] section of the Jitterbit.conf file.
- Optional: Set colour, if desired.
- Click OK.

- Once the connection has been created, expand the New Connection and expand Login Roles.
- Select Properties for the postgres user.
- Click on the Definition tab.
- Enter (and verify) a new password.
- Click OK.

Method 2
First, complete steps 1 through 7 above. Then complete these steps:
- Expand Databases under the new connection.
- Click on postgres.
- Click the SQL button to display the SQL Editor

- Execute this query:
alter user postgres with password 'Yourpasswordhere’
- Close and reopen PGAdmin.
- Log in with the updated password