How to reset the postgres (admin database user) password for the PostgreSQL server on cPanel servers

Introduction

The 'postgres' user is the database administrator account for PostgreSQL, similar to the 'root' user for MySQL. This article provides the steps needed to change 'postgres' user's password.

Please note that the "PostgreSQL Databases" application in cPanel must be used if you need to change the password for a non-administrative PostgreSQL user.

Also, it is important to note that this guide is intended for the PostgreSQL server that is used for storing the PostgreSQL databases that cPanel accounts make use of and not 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 uses. 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. Enter the new password in the two textboxes under "Postres Password."
4. Click the "Change Password" button.

Additional resources

PostgreSQL Databases: Change a PostgreSQL user password

Configure PostgreSQL: Postgres Password