3. Set up the database for ThingWorx
All ThingWorx database setup steps should be performed on all PostgreSQL nodes.
Step 0
Download ThingWorx install package.
Download the ThingWorx for PostgreSQL install package and extract its content to the /db/install folder.
Step 1
Create twadmin role.
psql
Step 2
Inside psql, using following command to create the twadmin role. Modify the password to meet your security requirements.
psql> create user twadmin with password 'trUf6yuz2?_Gub';
psql> alter role twadmin with createdb;
\q
psql> alter role twadmin with createdb;
\q
Step 3
Create the database.
Ensure /db/thingworx has been created and the postgres user is the owner of this folder.
Change directory to /db/install execute the following:
./thingworxPostgresDBSetup.sh -a postgres -u twadmin -l /db/thingworx
To verify this installation:
psql -d thingworx
\q
\q
Step 4
Grant privileges to twadmin.
psql
grant all privileges on database thingworx to twadmin;
\q
grant all privileges on database thingworx to twadmin;
\q
Step 5
Create Schema.
./thingworxPostgresSchemaSetup.sh
Step 6
Verify Schema.
psql -d thingworx -U twadmin
\dt
\dt
This should return results similar to the following:
