Skip to main content

Install Databases for PostgreSQL

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.

    Note

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

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

Prerequisites

  • 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 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:

trifacta-conf.json

No modifications to this file are required at this time.

Database Install

PostgreSQL 12

O/S Distribution

URL

Package Name

CentOS/RHEL 7

https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

postgresql12-server

CentOS/RHEL 8

https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

postgresql12-server

For CentOS/RHEL 7.x:

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:

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

Acquire Port Information

After you have completed the installation, you must acquire the port information for each database from the following locations on the Trifacta node. These port numbers need to be applied inside the Designer Cloud Powered by Trifacta platform.

Note

By default, PostgreSQL and the platform use port 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.

PostgreSQL 12

CentOS/RHEL:

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

Ubuntu:

/etc/postgresql/12/main/postgresql.conf

SSL

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