![]() |
The steps in this procedure use PostgreSQL version x.x, where x.x is the supported version.
|
![]() |
pgAdmin is an open source management tool for your databases that is included in the PostgreSQL download. The tool features full Unicode support, fast, multi-threaded query, and data editing tools and support for all PostgreSQL object types.
|
![]() |
Later in this process, this user is referred to as thingworxusername.
|
![]() |
This section is optional for development environments, but should be implemented in all production environments.
|
If you want to allow all IPv4 addresses to connect:
|
host all all 0.0.0.0/0 md5
|
If you want to allow only a specific IPv4 address to connect (Replace <ipAddress> with the IP address of the machine making the connection):
|
host all all <ipAddress>/32 md5
|
If you want to allow all IPv6 addresses to connect:
|
host all all ::0/0 md5
|
If you want to allow only a specific IPv6 address to connect (Replace <ipv6Address> with the appropriate address):
|
host all all <ipv6Address>/128 md5
|
![]() |
For additional information about configuring the pg_hba.conffile, see the official PostgreSQL documentation.
|
![]() |
Starting with ThingWorx 9.3.1, the ThingworxPostgresqlStorage folder creation or any -l parameter-related steps are no longer required, and the ThingWorx data will be stored at the default location of Postgresql.
|
![]() |
Starting with ThingWorx 9.3.1, tablespaces are no longer supported. It is not recommended to create a tablespace on the same file system as the data directory or on the same file system as another tablespace.
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
---|---|---|---|---|
-p or -P
|
port
|
5432
|
Port number of PostgreSQL
|
-p 5432
|
-d or -D
|
database
|
thingworx
|
PostgreSQL Database name to create
|
-d thingworx
|
-h or -H
|
host
|
localhost
|
Name of the host
|
-h localhost
|
-a or -A
|
adminusername
|
postgres
|
Administrator Name
|
-a postgres
|
-u or -U
|
thingworxusername
|
twadmin
|
User name that has permissions to write to the database.
|
-u twadmin
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
||
---|---|---|---|---|---|---|
-h or -H
|
host
|
localhost
|
IP or host name of the database.
|
-h localhost
|
||
-p or -P
|
port
|
5432
|
Port number of PostgreSQL.
|
-p 5432
|
||
-d or -D
|
database
|
thingworx
|
Database name to use.
|
-d thingworx
|
||
-s or -S
|
schema
|
public
|
Schema name to use.
|
-s myschema
|
||
-u or -U
|
username
|
twadmin
|
Username to update the database schema
|
-u twadmin
|
||
-o or -O
|
option
|
all
|
There are three options:
• all: Sets up the model and data provider schemas into the specified database.
• model: Sets up the model provider schema into the specified database.
• data: Sets up the data provider schema into the specified database.
|
-o data
|
![]() |
If your PostgreSQL server is not the same as your ThingWorx server, and you are having issues with your ThingWorx installation, review your Tomcat logs and platform-settings.json file. The default installation assumes both servers are on the same machine.
|