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 object-relational database management system, and one of the most popular alternatives to MySQL.

The reasons for its popularity include a long list of features like:

  • Multi-version concurrency control
  • Point in time recovery
  • Tablespaces
  • Asynchronous replication
  • Savepoints
  • Nested transactions
  • Query planner/optimizer
  • Write ahead logging for fault tolerance

There is also support for international character sets, multibyte character encodings, and Unicode. With locale-aware sorting, case sensitivity, and formatting – Postgres is an excellent alternate 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.

In this Guide:

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 the root user.
  2. Run the following command:
    /scripts/installpostgres
  3. You will then see a message similar to this:

    “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?“

  4. Type y then hit enter, to kick off the installation.
    Installing PostgreSQL via Command Line

    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 the root user.
  2. Click the Configure Postgres link in the SQL Services section.
    Configuring Postgres in WHM
  3. Click the Install Config button in the Postgres Config Install section.
    Installing Postgres Config
  4. A box will pop up and ask “Are you SURE you want to overwrite your current config file?” Click the OK button.
    Overwriting Postgres Config Settings

    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.
    Configuring Postgres in WHM
  3. Click the Create Users button in the Create Postgres Users section.
    Creating PostgreSQL Users

    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

Scale your business with high-performance dedicated hosting. Choose from Managed Dedicated Servers powered by cPanel, or select a Bare Metal Server for complete server control via the command line.

check markDDoS Protection check mark99.99% Uptime check markSoftware RAID check markNew Customer Discounts

Dedicated Hosting

JB
John-Paul Briones Content Writer II

John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

More Articles by John-Paul

Was this article helpful? Join the conversation!

Server Madness Sale
Score Big with Savings up to 99% Off

X