|
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.
|
|
The password, which should not be easily guessed or a known, common password, should be at least 14 characters in length and include a mix of uppercase and lowercase letters, numbers, and special characters. You will need to re-enter this password in later steps.
|
|
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.
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
---|---|---|---|---|
t or -T
|
tablespace
|
thingworx
|
Tablespace name
|
-t thingworx
|
-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
|
-l or -L
|
tablespace_location
|
/ThingworxPostgresqlStorage
|
Required. Location in the file system where the files representing database objects are stored.
|
-l or -L
|
-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.
|