Skip to main content

How to install and configure PostgreSQL

cPanelAaronH
  • Updated

Question

How do I install and configure PostgreSQL on my cPanel server?

Answer

CPANEL_INFO: Please note, PostgreSQL is not available on Ubuntu based servers.

cPanel & WHM version 118 and earlier
  1. Login to WHM as the root user.
  2. Navigate to Home / Server Configuration / Terminal

  3. Run the following command. 

    # /usr/local/cpanel/scripts/installpostgres

  4. Navigate to Home / SQL Services / Configure PostgreSQL
  5. Click on Install Config
  6. Click OK on the popup to install the config.
  7. Click on Configure PostgreSQL to navigate back to the interface.
  8. Click on Create Users
  9. Click on Configure PostgreSQL to navigate back to the interface.
  10. Click on Password Generator to create a password for the Postgres user.
  11. Click Change Password
cPanel & WHM version 120 and later
  1. Login to WHM as the root user.
  2. Navigate to Home / Server Configuration / Terminal

  3. Run the following command.

    # /usr/local/cpanel/scripts/installpostgres

  4. After the installation has completed, navigate to Home / Database Services / Configure PostgreSQL
  5. Click on Install Config
  6. Click OK on the pop-up to install the config.
  7. Click on Configure PostgreSQL to navigate back to the interface.
  8. Click on Create Users
  9. Click on Configure PostgreSQL to navigate back to the interface.
  10. Click on Password Generator to create a password for the Postgres user.
  11. Click Change Password

Additional Resources

Install or Update PostgreSQL® on Your cPanel & WHM Server

Configure PostgreSQL

Related articles

Comments

0 comments

Article is closed for comments.

%