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

The 

D s platform
rtrue
 requires access to the following databases.

  • Main database: storage of users and metadata about your datasets, including completed jobs.
  • Jobs database: storage of job tracking information. Jobs are purged upon completion or job timeout. Failed jobs are purged periodically. 
  • Configuration Service database: storage of parameter settings at the workspace level.
  • Artifact Storage Service database: storage for feature usage data such value mappings for the standardization feature.

The scheduling feature is enabled by default. If it's enabled, the following databases are also required:

  • Scheduling database: Storage of schedules, including datasets to execute
  • Time-based Trigger database: Storage of triggering information.
  • For more information, see Configure Automator.

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

Limitations

  • You must install a supported version of the database. For more information on supported versions of this database type, see System Requirements.
  • SSL connections are not supported.

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.

Select Configuration File

By default, the 

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

Code Block
/opt/trifacta/conf/trifacta-conf.json

Database Install

Excerpt


Info

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



For CentOS 6.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm
sudo yum -y install pgdg-centos96-9.6-3.noarch.rpm
sudo yum -y install postgresql96-server

For CentOS 7.x:

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

For Red Hat Enterprise Linux 6.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
sudo yum -y install pgdg-redhat96-9.6-3.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-redhat96-9.6-3.noarch.rpm
sudo yum -y install pgdg-redhat96-9.6-3.noarch.rpm
sudo yum -y install postgresql96-server

For Ubuntu 14.04:

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

Code Block
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:

Code Block
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
deb-src http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

Run the following command:

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


For Ubuntu 16.04:

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

Code Block
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:

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

Run the following command:

Code Block
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 

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

d-s-pssql-port

CentOS/RHEL (PostgreSQL 9.6):

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

Ubuntu (PostgreSQL 9.6) :

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