|
It is recommended to have ThingWorx Server and Azure PostgreSQL Flexible Server at the same geographical location.
|
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
|
||
-l or -L
|
tablespace_location
|
/ThingworxPostgresqlStorage
|
Required in ThingWorx 9.3.0 and before. Location in the file system where the files representing database objects are stored. User needs to create this folder manually with permissions before executing the script and then specify the path, for example, -l D:\ThingworxPostgresqlStorage.
|
-l or -L
|
||
-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
|