Change Postgres Admin Password

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 Object > Change Password. Enter the current and new passwords.

   

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