Symptoms
When attempting to access PostgreSQL, you encounter an error similar to the following.
psql: FATAL: password authentication failed for user "postgres"
Description
The issue occurs when the 'postgres' user's password is incorrect or corrupt. Resetting the password will correct the issue.
Workaround
- Log into WHM as the ‘root’ user.
- Navigate to "Home / Database Services / Configure PostreSQL."
- Enter a new PostgreSQL password in the "Enter New Password" textbox.
- Re-enter the password in the "Confirm Password" textbox.
- Click the "Change Password" button.