ThingWorx Flow Prerequisites for PostgreSQL
The following sections provide information about the prerequisites that you need to set before you install ThingWorx Flow:
Prerequisites for Windows Server 2016 with PostgreSQL
• Windows Server 2016 with Administrator access
• A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
|
Database Connection
|
Prerequisites
|
|---|---|
|
Local database connection
|
• PostgreSQL installed, and the path to PostgreSQL/bin should be in the PATH environment variable.
• The host on which ThingWorx Flow is to be installed must have access to the PostgreSQL server.
• Updated the pg_hba.conf file to allow connections to PostgreSQL from the ThingWorx Flow host.
For example, if ThingWorx Flow is installed on the same host as PostgreSQL, update the pg_hba.conf file to set the password authentication method to md5, password, or trust. However, trust is not recommended.
The following is an example of the pg_hba.conf file with password authentication set to md5:
$ Edit pg_hba.conf for following:
... # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 For more information about the pg_hba.conf file, see this link.
|
|
Remote database connection
|
• Install the psql client that is compatible with your PostgreSQL version.
• Add the installed psql to the PATH environment variable. You can follow these steps:
1. Download pgadmin4-4.1-x86.exe from https://www.postgresql.org/ftp/pgadmin/pgadmin4/v4.1/windows/.
2. Install the pgadmin client.
3. Update the PATH environment variable to append to the path where the pgadmin client is installed.
|
• PostgreSQL database that can be used for ThingWorx Flow. You can use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Set the following configuration settings on the database:
◦ Set the connection limit property to -1.
◦ Set the Allow Connections? property to Yes.
◦ Set the Encoding property to UTF-8.
 |
Ensure that you have not used this database for a previous ThingWorx Flow installation.
|
• Ensure that your database user has the following settings and privileges:
◦ Set the database user as the owner of the database.
◦ Set the Can login? property to Yes.
◦ Grant all privileges on the database to the database user.
Prerequisites for Red Hat Enterprise Linux 7.5, 7.6, 8.0, 8.1, or 8.2 with PostgreSQL
|
|
Ensure that you are installing ThingWorx Flow on the supported version of Red Hat Enterprise Linux. For more information, see Supported operating systems.
|
• Red Hat Enterprise Linux (RHEL) 7.5 with Administrator access
• In the /etc/selinux/config file, set SELINUX=enforcing, and restart the machine.
• Run the following commands to enable Software Collections:
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RHSCL (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Extra(RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Optional (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RH Common (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Supplementary (RPMs)'
• Run the following commands to enable EPEL repository:
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum localinstall epel-release-latest-7.noarch.rpm
• A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
|
Database Connection
|
Prerequisites
|
|---|---|
|
Local database connection
|
• PostgreSQL installed, and the path to PostgreSQL/bin should be in the PATH environment variable.
• The host on which ThingWorx Flow is to be installed must have access to the PostgreSQL server.
• Updated the pg_hba.conf file to allow connections to PostgreSQL from the ThingWorx Flow host.
For example, if ThingWorx Flow is installed on the same host as PostgreSQL, update the pg_hba.conf file to set the password authentication method to md5, password, or trust. However, trust is not recommended.
The following is an example of the pg_hba.conf file with password authentication set to md5:
$ Edit pg_hba.conf for following:
... # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 For more information about the pg_hba.conf file, see this link.
|
|
Remote database connection
|
Install the psql client that is compatible with your PostgreSQL version.
|
• PostgreSQL database that can be used for ThingWorx Flow. You can use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Set the following configuration settings on the database:
◦ Set the connection limit property to -1.
◦ Set the Allow Connections? property to Yes.
◦ Set the Encoding property to UTF-8.
|
|
Ensure that you have not used this database for a previous ThingWorx Flow installation.
|
• Ensure that your database user has the following settings and privileges:
◦ Set the database user as the owner of the database.
◦ Set the Can login? property to Yes.
◦ Grant all privileges on the database to the database user.
• From your PosgreSQL database, note the following values:
◦ PostgreSQL IP Address or Host Name
◦ PostgreSQL Port
◦ ThingWorx Flow Database Name
◦ ThingWorx Flow Database Login Username
◦ ThingWorx Flow Database Login Password