How to get PostgreSQL on a VPS / Dedicated Server

In this guide we will show you how to install PostgreSQL on a VPS or Dedicated server. PostgreSQL is a free open-source database management system, and one of the most popular alternatives to MySQL. After it is installed, we will show you how to configure Postgres; which will add phpPgAdmin to cPanel. By using phpPgAdmin, you can easily access and modify the tables in your PostgreSQL database.

You must have root access to your server to complete this guide! PostgreSQL, and phpPgAdmin are already installed on all shared servers.

Installing PostgreSQL via SSH

  1. SSH into your server as root.
  2. Run the following command:
    /scripts/installpostgresYou will then see a message stating “This script will install PostgreSQL 7.4.x or later If you have an older version installed you will need to Dump your databases to a file and then restore them after the install as 7.4.x is not backwards compatible. If you do not have any databases, you can just run:
    mv /var/lib/pgsql /var/lib/pgsql.old
    /sbin/service postgresql stop
    /sbin/service postgresql start
    to force creating a 7.4.x style setup. Do not do this if you have databases that you wish to keep!

    Are you sure you wish to proceed?

  3. Type y then hit enter, to kick off the installation.

    The process is finished when you are able to type in the command prompt again.

Submit a Ticket Request

If you need assistance installing PostgreSQL, or want to install a different version of PostgreSQL, please contact our Managed Hosting team.

Configuring Postgres

We will now show you how to configure Postgres, you will then be able to access phpPgAdmin in cPanel. This is a 2-step process.

Step 1: Get phpPgAdmin

  1. Login to WHM as root.
  2. Click the Configure Postgres link in the SQL Services section.

  3. Click the Install Config button in the Postgres Config Install section.

    A box will pop-up and ask “Are you SURE you want to overwrite your current config file?” Click the OK button.

    It is finished when you see a message stating “ALTER ROLE Configuration successfully updated

Step 2: Creating Postgres Users

In this second step you will now create the Postgres Users in WHM. This and all steps in this tutorial are required to allow you to use PostgreSQL in your cPanel.

  1. Login to WHM as root.
  2. Click the Configure Postgres link in the SQL Services section.

  3. Click the Create Users button in the Create Postgres Users section.

    You are finished when you see a message stating “PostgreSQL users created

Congratulations, now you know how to install, and configure PostgreSQL on your VPS or Dedicated server! Learn more about PostgreSQL Hosting

Was this article helpful? Let us know!