Change Postgres Admin Password

Last modified: May 17, 2021

To change your Postgres admin password, and connect to Analytics Hub using the new credential:

  1. Stop Analytics Hub. To do so, open Windows PowerShell as an admin and run the ayxhub script with stop command.
     .\ayxhub.ps1 -stop
  2. Open the pgAdmin 4 app. If this is the first time you're opening pgAdmin 4, you're prompted to create a master password which is used to protect passwords to your server connections.
  3. Select your PostgreSQL server under Servers and enter the admin password. 
  4. Select ObjectChange Password. Enter the current and new passwords.

    Screenshot of change password modal in PgAdmin

  5. Select OK.
  6. Open Windows PowerShell as an admin.
  7. Run the ayxhub script to update the password that Analytics Hub is using.
    .\ayxhub.ps1 -db <Postgres_Admin_Username> <New_Password>
  8. Start Analytics Hub.
     .\ayxhub.ps1 -start
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.