Resetting the Private Agent PostgreSQL Admin Password

Introduction

Here are a two methods of changing the PostgreSQL password in a Harmony environment. Method 1 is the most direct.

Method 1

1. Launch PGAdmin
2. Click File and select Add Server.
3. Enter a name for the connection.
4. Change the username from ‘postgres’ to ‘jitterbit’.
5. Populate the password found in the [DbInfo] section of the Jitterbit.conf file.
6. Optional: Set colour, if desired.
7. Click OK.
   
8. Once the connection has been created, expand the New Connection and expand Login Roles.
   1. Select Properties for the postgres user.
   2. Click on the Definition tab.
   3. Enter (and verify) a new password.
   4. Click OK.
      

Method 2

First, complete steps 1 through 7 above. Then complete these steps:

1. Expand Databases under the new connection.
2. Click on postgres.
3. Click the SQL button to display the SQL Editor 
4. Execute this query:  alter user postgres with password 'Yourpasswordhere’
5. Close and reopen PGAdmin.
6. Log in with the updated password