Installing Pivotal Postgres

This topic describes how to download and install components of the Pivotal Postgres software distribution. PostgreSQL Database and the Replication Manager are core parts of the product distribution, while the ODBC and JDBC drivers can be installed onto client machines as necessary for your applications.

Prerequisites

  • Your deployment systems must meet the system requirements described in Supported Platforms.
  • You must have root permissions to install the software.
  • Ensure that you have not installed Red Hat Enterprise Linux PostgreSQL on the same system. Pivotal Postgres cannot be installed alongside RHEL PostgreSQL at this time.

Installing PostgreSQL Database and Replication Manager (repmgr)

Perform this procedure on each host that will participate in the Pivotal Postgres cluster:

  1. Download the Pivotal Postgres Database and Replication Manager (repmgr) software distributions from Pivotal Network.

    • The PostgreSQL database download filename has the format: pivotal-postgres-<postgres-version>-<pivotal-version>.<platform>.<architecture>.rpm
    • The repmgr download filename has the format: pivotal-postgres-repmgr-<repmgr-version>-<pivotal-version>.<platform>.<architecture>.rpm

  2. Login to your system as root, or use sudo in the next step as necessary to acquire root privileges.

  3. Navigate to the downloaded RPM files and install them using the yum utility. For example:

    $ cd ~/Downloads
$ yum install pivotal-postgres-11.1-1.el7.x86_64.rpm
$ yum install pivotal-postgres-repmgr-4.2-1.el7.x86_64.rpm

  4. Continue to set up and start the PostgreSQL server, as described in Server Setup and Operation in the PostgreSQL documentation.

  5. Install ODBC/JDBC client software on client client machines, or follow the instructions in Configuring and Using Pivotal Postgres to configure the PostgreSQL cluster with repmgr.

Installing the Pivotal Postgres ODBC Driver

  1. Download the Pivotal Postgres ODBC driver software distribution from Pivotal Network.


    The ODBC driver download filename has the format: pivotal-postgres-odbc-<odbc-version>-<pivotal-version>.<platform>.<architecture>.rpm

  2. Login to your system as root, or use sudo in the next step as necessary to acquire root privileges.

  3. Navigate to the downloaded RPM file and install it using the yum utility. For example:

    $ cd ~/Downloads
$ yum install pivotal-postgres-odbc-11.00-0000-1.el7.x86_64.rpm

Installing the Pivotal Postgres JDBC Driver

  1. Download the Pivotal Postgres JDBC driver software distribution from Pivotal Network.


    The JDBC driver download filename has the format: pivotal-postgres-jdbc-<jdbc-version>-<pivotal-version>.<platform>.<architecture>.jar.zip. For example, pivotal-postgres-jdbc-42.2.5-1.el7.x86_64.jar.zip.

  2. Unzip the downloaded file to obtain the driver JAR file:

    $ unzip pivotal-postgres-jdbc-*.jar.zip

  3. The JDBC driver JAR is not installed at the system level; simply include it in your Java CLASSPATH as necessary to connect using the driver. See Setting up the Class Path in the JDBC Driver documentation for more information.