Configure PostgreSQL

Configure PostgreSQL

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.

Notes:

The system grades 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 Generator - x3 documentation.


  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Additional MySQL Access Hosts

Additional MySQL Access Hosts This interface allows you to permit remote hosts (servers) to...

Change MySQL User Password

Change MySQL User Password This interface allows you to change a database user's password....

Database Map Tool

Database Map Tool This feature allows server administrators to grant ownership of database...

MySQL Root Password

MySQL Root Password This interface allows you to set the MySQL® root password. Warnings:...

Manage MySQL® Profiles

  Manage MySQL® Profiles This interface allows you to manage multiple MySQL® server profiles. A...