Location: SQL Services/Postgres Config
The Postgres Config utility will install a Postgres authentication configuration file that uses md5 passwords which works with cPanel. If you already have a working Postgres setup this will overwrite your current pg_hba.conf. You should not use this unless you are installing Postgres for the first time.
Install Config
1. When the page loads, click on the "Install Config" button.
2. You should see a statement similar to the following:
"Setting up Postgres Config...Done
Reloading Postgres...Done
The Postgres config install has been completed."
Change Postgres Password
1. When the page loads, enter the new password in the "New Password" text box.
2. Click on the "Change Password" button.
3. You should see a statement similar to the following:
"Setting up Postgres Config...Done
Reloading Postgresql...postmaster successfully signaled
Done
Changing Password....ALTER USER
Done
Reloading Postgresql...postmaster successfully signaled
Done
The Postgresql Password has been changed"