Knowledgebase

Configure PostgreSQL  Print this Article

Overview:

This interface allows you to complete the PostgreSQL® installation process, create PostgreSQL users, and update the PostgreSQL password.

Warning:
This interface’s features are for advanced users only. The WHM interface only displays this interface if you have already installed PostgreSQL on your server.

Postgres Config Install

After you install PostgreSQL on your server via the command line, you must use this interface to complete the installation process. To do this, click Install Config.

Warning:
Only use this feature to complete the PostgreSQL installation process. If a functional installation of PostgreSQL already exists on your server, this feature will overwrite the current pg_hba.conf file.

Create Postgres Users

If cPanel accounts already exist on your server, you must create PostgreSQL accounts after the PostgreSQL installation process finishes. To do this, click Create Users.

Note:
When you create new cPanel accounts on a server that already has PostgreSQL installed, the system automatically creates the new cPanel account’s PostgreSQL user. Only use this feature to create PostgreSQL users for existing cPanel accounts, immediately after you install PostgreSQL.

Postgres Password

To update your PostgreSQL password, enter the new password in the text boxes and click Change Password.

Enter and confirm the new password in the appropriate text boxes.

Note:
  • The system evaluates the password that you enter on a scale of 100 points. 0 indicates a weak password, while 100 indicates a very secure password.

  • Some web hosts require a minimum password strength. A green password Strength meter indicates that the password is equal to or greater than the required password strength.

  • Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.

Was this answer helpful?

Related Articles

Additional MySQL Access Hosts
Overview: This interface allows you to permit remote hosts (servers) to access MySQL® databases...
Change MySQL User Password
Overview: This interface allows you to change a database user’s password. Because this feature...
Database Map Tool
Overview: This feature allows server administrators to grant ownership of database objects...
Manage Database Users
Overview This interface allows server administrators to retrieve a list of database users, each...
Manage Databases
Overview: This interface allows you to list cPanel-managed databases on your server, each...