Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 bring up the 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
Panel
borderColor#65379B
titleColor#FFFFFF
titleBGColor#65379B
titleOn This Page
Table of Content Zone

Table of Contents
maxLevel3
minLevel2

Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics

HideElements
metastrue

Last updated: 

Lastmodifieddate