Installing and Configuring PostgreSQL HA
The guidelines provided below are to support the implementation of the previous diagram. They are intended for the PostgreSQL administrators and users implementing a PostgreSQL HA deployment.
 |
PTC technical support does not support PGPool installation, configuration, or troubleshooting. For PGPool installation and configuration support, see PGPool Documentation and Pgpool Wiki.
|
Reference Documents
Before installing PostgreSQL, read and understand all installation and configuration documents, including any documentation for required prerequisite software. It is important to understand and apply proper settings, including security recommendations.
The following links provide useful information for the installation and configuration of PostgreSQL HA using streaming replication and Pgpool-II for node management.
• For PostgreSQL version 11 compatibility:
• For PostgreSQL version 13 and later compatibility:
For more help with PGPool II, contact the PGPool community.
• For all versions of PostgreSQL:
Installing PostgreSQL and Creating a New User Role in PostgreSQL
Instructions to install and configure PostgreSQL are provided in the Installing ThingWorx guide. Refer to the install guide for the specific version of ThingWorx to be deployed. The same install and configure tasks must be performed on all three PostgreSQL nodes.
Configuring and Executing the PostgreSQL Database Script
Instructions to build the database within PostgreSQL are provided in the Installing ThingWorx guide. Refer to the install guide for the specific version of ThingWorx to be deployed. The same install and configure tasks should be performed on all three PostgreSQL nodes.
Configuring and Executing the Model/Data Provider Schema Script
Instructions to build the ThingWorx schema within PostgreSQL are provided in the Installing ThingWorx guide. Please refer to the install guide for the specific version of ThingWorx to be deployed. The same configure tasks should be performed on all three PostgreSQL nodes.
Install PGPool II Following Installation and Configuration Documents
To install PGPool II, refer to PGPool documentation.
Configuring SSL/TLS for PostgreSQL
To configure SSL/TLS for PostgreSQL, see Configuring SSL/TLS for PostgreSQL