Installing ThingWorx Flow on PostgreSQL
This topic provides the steps to install ThingWorx Flow on Windows Server 2016 or Red Hat Enterprise Linux (RHEL), if you are using the PostgreSQL database.
Installation Process
Use the ThingWorx Flow for PostgreSQL Setup installation tool to install ThingWorx Flow on your operating system.
* 
If you are installing ThingWorx Flow on Windows, it is recommended that you disable your antivirus temporarily during installation.
* 
The ThingWorx Flow installation tool on Red Hat Enterprise Linux is designed to work with an internet connection. If you plan to install ThingWorx Flow on Red Hat Enterprise Linux without an internet connection, do the following:
1. Run the following commands to install all third-party software on another Linux box that has an internet connection:
yum install 'nginx'
yum install 'rh-nodejs8'
yum install 'rabbitmq'
yum install 'openssl'
yum install 'policycoreutils-python'
2. Configure the yum package manager on the box where you plan to run the installer to set this box as a yam dependency.
Open the installation tool
1. Log in to the system where you want to install ThingWorx Flow as administrator.
2. According to the installation package that you downloaded, unzip the download and then open the installer file.
For Windows, double-click to open the installation tool.
For Linux, run the installation tool with the root user.
Welcome to ThingWorx Flow
Click Next to begin with the installation for ThingWorx Flow.
Getting ready to install
Ensure that you set all prerequisites required for installation. You can find detailed prerequisites at ThingWorx Flow Prerequisites for PostgreSQL.
Click Next.
Applications in this installer
This installation tool helps you install ThingWorx Flow on your system.
License agreement
1. Read the license agreement, and then select I accept the agreement. You can print a copy of the agreement.
2. Click Next.
Installation location
Specify the location where you want to install ThingWorx Flow.
1. Click to set the installation location, or accept the default location:
Windows—C:\Program Files (x86)
Linux—/opt
Make sure that you install ThingWorx Flow in a location that has at least 100 GB of free disk space.
2. Click Next.
ThingWorx Flow configuration information
Follow these steps to set up a connection with ThingWorx Foundation:
1. In the IP Address or Host Name of ThingWorx Foundation field, specify the host name of the ThingWorx Foundation instance.
2. In the Local Port of ThingWorx Foundation field, specify the port where ThingWorx Foundation is deployed.
3. Depending on how you set up ThingWorx Foundation, under Protocol to access Foundation, select HTTP (insecure) or HTTPS (secure).
4. In the ThingWorx Foundation Settings File Path (platform-settings.json) field, click to specify the location of the platform-settings.json file.
If you are installing ThingWorx Flow on a different machine than ThingWorx Foundation, refer to Installing ThingWorx Flow on a Different Machine than ThingWorx Foundation to understand how you can provide the platform-settings.json file.
5. Click Next.
PostgreSQL connection information
1. To establish a connection with PostgreSQL, enter the following details:
PostgreSQL IP Address or Host Name—Enter the fully qualified host name.
PostgreSQL Port—Enter the SQL server port. The default is 5432.
2. To connect to the database that you want to use for ThingWorx Flow, enter the following details:
ThingWorx Flow Database Name—Enter the name of the database that you want to use for ThingWorx Flow.
ThingWorx Flow Database Login Username—Enter the user name of the database owner.
ThingWorx Flow Database Login Password—Enter the password of the database owner.
* 
You can use the same persistence provider that you used for ThingWorx Foundation.
The installer validates the PostgreSQL connection and checks if the database user that you provided has the owner privileges on the database. If you receive an error message, check the details that you specified here and the permissions that you assigned to the database user. For detailed information about the required privileges for the database user, see ThingWorx Flow Prerequisites for PostgreSQL.
Properties for ThingWorx Flow
Specify the following properties for ThingWorx Flow:
1. In the Hostname for ThingWorx Flow field, enter one of the following values:
Host name of the machine where you are installing ThingWorx Flow
If ThingWorx was already deployed, it is recommended to reuse the host name that been used for the ThingWorx instance.
This configuration allows users to avoid having to change their bookmarks or learn a new URL. However, you must modify the value of the name attribute in the Host tag in the server.xml file under the Tomcat installation.
2. In the Local HTTPS Port for ThingWorx Flow, specify the HTTPS port where you want to deploy ThingWorx Flow. The default is 443.
3. Click Next.
Configuration summary
This screen provides the ThingWorx Flow installation directory and the ThingWorx Flow HTTPS port.
1. Review the information about your installation.
2. If you need to change anything, click Back. When you are ready, click Next to start the installation.
If you are installing ThingWorx Flow on Windows, it is recommended that you disable your antivirus temporarily during installation.
The entire setup takes about 20 minutes depending on the host hardware configuration.
* 
During the final stages of installation, a console window is launched. Do not close or right-click the console window. The window closes automatically after the installation is complete.
3. Click Finish to close the installation window.
You have successfully installed ThingWorx Flow.
Verification
Run the ValidateFlowConnectivity service to verify ThingWorx Flow connectivity.
To verify that ThingWorx Flow is installed correctly, start Command Prompt and execute the following command:
pm2 ls
The status of the following ThingWorx Flow components must be ‘online’:
flow-api
flow-engine
flow-exchange
flow-lookup
flow-oauth-server
flow-trigger
Was this helpful?