Configure PostgreSQL

Valid for versions 82 through the latest version


Last modified: September 29, 2020

Overview

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

Warning:
This interfaces 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 accounts 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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Additional MySQL Access Hosts

Valid for versions 82 through the latest version Last modified: November 30, 2022...

Change MySQL User Password

Valid for versions 82 through the latest version Last modified: September 29, 2020...

Database Map Tool

Valid for versions 82 through the latest version Last modified: May 13, 2020 Overview...

Edit SQL Configuration

Valid for versions 104 through the latest version Last modified: August 9, 2022...

Manage Database Users

Valid for versions 102 through the latest version Last modified: December 7, 2022...