PostgreSQL

PostgreSQL

WHM/cPanel does support PostgreSQL to be installed on your CentOS server. cPanel does recommend that you have an experienced PostgreSQL db administrator for installation, upgrading, and managing this db engine. While the version of CentOS/RedHat is not required for installation of PostgreSQL you can however check the version of CentOS running the following.

    cat /etc/centos-release

Databases Backup

It is highly recommend that you backup your databases before upgrading PostgreSQL. Please visit cPanel docs on how to backup your databases before upgrading on PostgreSQL on cPanel: [docs.cpanel.net]

Installing PostgreSQL on your cPanel server

To begin the installation, SSH into the server and run the following command:

   /scripts/installpostgres

Configure PostgreSQL Installation in WHM

Log into WHM/cPanel using your root user/password that came with the welcome email sent when the server was setup.

1. Access Configure Postgres in WHM through "SQL Services"
2. Click the Install Config button. NOTE: If PostgreSQL is already installed on the server this will overwrite the configuration of the current installation.
3. Click Create Users
4. Enter a new password for user