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

Limitations

NOTE: Installation of the databases into any database schema other than PUBLIC is not supported.


Pre-requisites

Select Configuration File

By default, the  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:

/opt/trifacta/conf/trifacta-conf.json

No modifications to this file are required at this time.

Database Install


NOTE: The following distributions and commands are for PostgreSQL 9.6.


O/S DistributionURLPackage Name
CentOS 7

https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm

postgresql96-server
CentOS 8https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpmpostgresql96-server
RHEL 7

https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm

postgresql96-server
RHEL 8

https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm

postgresql96-server


For CentOS 7.x:

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:

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:

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:

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 Ubuntu 16.04:

Add the repository's archive key to your apt-key keyring:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Create a file named /etc/apt/sources.list.d/pgdg.list, containing the following:

deb http://apt.postgresql.org/pub/repos/apt/xenial-pgdg main

Run the following command:

sudo apt-get update
sudo apt-get install -y postgresql-9.6

For Ubuntu 18.04:

Add the repository's archive key to your apt-key keyring:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Create a file named /etc/apt/sources.list.d/pgdg.list, containing the following:

deb http://apt.postgresql.org/pub/repos/apt/bionic-pgdg main

Run the following command:

sudo apt-get update
sudo apt-get install -y postgresql-9.6



Acquire Port Information

After you have completed the installation, you must acquire the port information for each database from the following locations on the . These port numbers need to be applied inside the .

CentOS/RHEL (PostgreSQL 9.6):

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

Ubuntu (PostgreSQL 9.6) :

/etc/postgresql/9.6/main/postgresql.conf