Contents:
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.
- You must install a supported version of the database. For more information on supported versions of this database type, see System Requirements in the Planning Guide.
- 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 Designer Cloud Powered by Trifacta 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:
/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 Distribution | URL | Package Name |
|---|---|---|
| CentOS 7 | postgresql96-server | |
| CentOS 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 |
| RHEL 7 | postgresql96-server | |
| RHEL 8 | 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 Alteryx node. These port numbers need to be applied inside the Designer Cloud Powered by Trifacta platform.
5432 for communication. If that port is not available at install/upgrade time, the next available port is used, which is typically 5433. This change may occur if a previous version of PostgreSQL is on the same server. When a non-default port number is used, the platform must be configured to use it. For more information, see Change Database Port.CentOS/RHEL (PostgreSQL 9.6):
/var/lib/pgsql/9.6/data/postgresql.conf
Ubuntu (PostgreSQL 9.6) :
/etc/postgresql/9.6/main/postgresql.conf
This page has no comments.