Introduction
You may use the following procedure to reset the password for the postgres user for the PostgreSQL database on cPanel servers. The postgres user is the database administrator for PostgreSQL, similar to the root user on MySQL servers.
If you need to change the password for non administrative PostgreSQL users, please use the "PostgreSQL Databases" icon within your cPanel account.
Please note that this guide is intended for the PostgreSQL server that is used for storing the PostgreSQL databases that cPanel accounts make use of.
This does not apply to the PostgreSQL database that is installed and running for the CCS (Contacts and Calendars Server) plugin. The PostgreSQL database installed with the CCS plugin is not intended for use or interaction other than the automated database transactions that cPanel software makes use of. If you need assistance with the CCS database, please reach out to cPanel support before making any changes.
Procedure
1. Login to WHM as the root user
2. Navigate to: Home »SQL Services »Configure PostgreSQL
3. Scroll to the bottom and enter your desired password twice
4. Click the blue "Change Password" button