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

Version 1 Next »

 

There are a couple of methods to changing the postgres password in a Harmony environment if forgotten.

  1. Most direct:
    Launch PGAdmin
  2. Click File -> Add Server
  3. Give the connection a name
  4. Change username from ‘postgres’ to ‘jitterbit’
  5. Populate the password found in the [DbInfo] section of the Jitterbit.conf file
  6. Set colour(if desired)
  7. Click Ok

 

Once the connection has been created, expand the new connection, and expand Login Roles

8a.          Select “Properties” for the postgres user

9a.          Click on the “Definition” tab

10a.        Enter (and verify) a new password

11a.        Click “Ok”

 

Option 2:

Complete steps 1-7 above

8b.  Expand Databases under the new connection

9b.  Click on postgres

10b.  Click the SQL button to bring up the SQL editor 

11b.  Execute this query:

alter user postgres with password 'Yourpasswordhere’

12b.  Close and reopen PGAdmin, and login in with the updated password

Heading 2

EXAMPLE: Use to call out examples or next steps.
NOTE: Use to call out informational notes.
NOTE: Use to provide notes of caution.

NOTE: Use for warning with extreme emphasis.

Heading 3

Quoted text

Heading 2

Heading 3

  • Bullet
    1. Step 1
      1. Sub-step 1
      2. Sub-step 2
    2. Step 2
      • Bullet
      • Bullet
  1. Step 1
    • Bullet
      1. Sub-step 1
      2. Sub-step 2
    • Bullet
  2. Step 2
    1. Sub-step 1
    2. Sub-step 2

Heading 3

Regular Code Block
Code block
Collapsed Code Block
Code block
On This Page

Related Articles

There is no content with the specified labels

Related Topics

There is no content with the specified labels

Last updated:  Aug 09, 2017


  • No labels