Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

This section describes how to install the PostgreSQL database server, after which you can create and initialize the databases and their users.

Limitations

  • You must install a supported version of the database. 

    Info

    NOTE: Support for PostgreSQL 9.6 is deprecated for customer-managed Hadoop-based deployments and AWS deployments. PostgreSQL 9.6 is supported only for Azure deployments. When Azure supports PostgreSQL 12 or later, support for PostgreSQL 9.6 will be deprecated in the subsequent release of

    D s product
    .

  • For more information on supported versions of this database type, see System Requirements in the Planning Guide.

Pre-requisites

  • The installing user must have write permissions to the directory from which the commands are executed.
  • The installing user must have sudo privileges.
  • The database client should already be installed. See Install Database Client for PostgreSQL.

Select Configuration File

By default, the 

D s platform
 assumes that you are installing the databases in a PostgreSQL instance, which is reflected in the default platform configuration file. This configuration file is stored here:

D s triconf
pathtrue

No modifications to this file are required at this time.

Database Install

Excerpt

PostgreSQL 12

For CentOS/RHEL 7.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install postgresql12-server

For CentOS/RHEL 8.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install postgresql12-server

PostgreSQL 9.6


For CentOS 7.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server

For CentOS 8.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server

For Red Hat Enterprise Linux 7.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server


For Red Hat Enterprise Linux 8.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server


Acquire Port Information

After you have completed the installation, you must acquire the port information for each database from the following locations on the 

D s node
. These port numbers need to be applied inside the 
D s platform
.

d-s-pssql-port

PostgreSQL 12

CentOS/RHEL:

Code Block
/var/lib/pgsql/12/data/postgresql.conf


Ubuntu:

Code Block
/etc/postgresql/12/main/postgresql.conf

PostgreSQL 9.6

CentOS/RHEL):

Code Block
/var/lib/pgsql/9.6/data/postgresql.conf


Ubuntu (PostgreSQL 9.6):

Code Block
/etc/postgresql/9.6/main/postgresql.conf

SSL

Support for SSL requires additional configuration. For more information, see Enable SSL for Databases.