Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

here are a 2 methods to change the PostgreSQL password in a Harmony environment.

Method 1 - Most Direct

  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 the following steps:

  1. Expand Databases under the new connection.
  2. Click on postgres.
  3. Click the SQL button to bring up 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
On This Page

Related Topics

Last updated:  Aug 09, 2017

  • No labels