Versions Compared

Key

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

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.
    Image Modified
  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.
      Image Modified

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 Image Modified
  4. Execute this query:  alter user postgres with password 'Yourpasswordhere’
  5. Close and reopen PGAdmin.
  6. Log in with the updated password

...

Easy Heading Free
headingIndent0
expandOptiondisable-expand-collapse
navigationTitleOn This Page

...

wrapNavigationText

...

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

true

...

maxLevel3
minLevel2

navigationExpandOptionexpand-all-by-default

HideElements
metastrue

...