Install the Databases

The Designer Cloud Powered by Trifacta® platform requires access to two Postgres 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. 

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 Scheduling.

This section describes how to install Postgres, 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.

For CentOS 6.x:

wget https://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-3.noarch.rpm
sudo yum -y install pgdg-centos93-9.3-3.noarch.rpm
sudo yum -y install postgresql93-server

For CentOS 7.x:

wget https://yum.postgresql.org/9.3/redhat/rhel-7-x86_64/pgdg-centos93-9.3-3.noarch.rpm
sudo yum -y install pgdg-centos93-9.3-3.noarch.rpm
sudo yum -y install postgresql93-server

For Red Hat Enterprise Linux 6.x:

wget https://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-redhat93-9.3-3.noarch.rpm
sudo yum -y install pgdg-redhat93-9.3-3.noarch.rpm
sudo yum -y install postgresql93-server

For Red Hat Enterprise Linux 7.x:

wget https://yum.postgresql.org/9.3/redhat/rhel-7-x86_64/pgdg-redhat93-9.3-3.noarch.rpm
sudo yum -y install pgdg-redhat93-9.3-3.noarch.rpm
sudo yum -y install postgresql93-server

For Ubuntu 14.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/ trusty-pgdg main
deb-src http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

Run the following command:

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

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.3