Reset A User Password

User passwords are managed with the pgAdmin tool that's installed alongside of the PostgreSQL database. Follow the steps below to update or reset a user's password.

1. Open the PgAdmin application.
2. On the left side of PgAdmin, you'll see Servers. Use the arrow to expand the list.
   
3. After expanding the Servers list you should see PostgreSQL followed by the version number
   
4. Double-click on PostgreSQL to log in to the database.
   

   You may be prompted for a password. This is the master password that was created when Postgres was first installed on the computer. (This is usually different than the password used to log into the programs.)

   
5. After logging in, use the arrow to expand the Login/Group Roles section. This will produce a list of all Users and Group Roles.
   
6. Right click on the user, then select Properties.
7. In the User Properties window, select the Definition tab.
   
8. Enter a new password in the Password field then press Save.
9. Use the new password when logging in to Budget, Payroll, and ABReport.