How to install and configure PostgreSQL

Introduction

This how-to will tell you how to install PostgreSQL on your server and where to find information on configuring the service.

Procedure

If PostgreSQL has not yet been installed on your server, the following command will install the OS provided version of PostgreSQL that cPanel supports:

/usr/local/cpanel/scripts/installpostgres

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

If you are trying to update an existing installation, the following documentation can show you how to backup your databases before running the installer:

Install or Update PostgreSQL® on Your cPanel & WHM Server

Once installed, documentation on the Configure PostgreSQL tool in cPanel can be found here:

Configure PostgreSQL