Getting Started with ThingWorx > Installing and Upgrading ThingWorx > Windows Installation > PostgreSQL > Install and Configure PostgreSQL (Windows)
  
Install and Configure PostgreSQL (Windows)
The instructions provided below are intended for the PostgreSQL administrator (not the DB host servers).
* 
If you are including the HA layer to your implementation, refer to the ThingWorx High Availability Administrator’s Guide.
Install PostgreSQL and Create a New User Role
1. Download and install the appropriate version of PostgreSQL from the following site: http://www.postgresql.org/download/
* 
Refer to the System Requirements document for information on supported versions.
2. Open PostgreSQL using pgAdmin III.
* 
pgAdmin III 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.
3. Create a new user role:
a. Right click PostgreSQL9.x (<IP or host name of the database>:<Port number of PostgreSQL>). Example: PostgreSQL9.x (localhost:5432)
b. Select New Object>New Login Role. On the Properties tab, in the Role name field, enter the <PostgreSQL user role name> for PostgreSQL administration.
c. On the Definition tab, in the Password field, enter a unique and secure password for PostgreSQL administration (you will be prompted to enter it twice).
* 
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.
4. Click OK.
* 
Remember the user role name created in this step for later use.
Configure PostgreSQL Database Located on a Separate Server than ThingWorx
* 
This section is optional for development environments, but should be implemented in all production environments.
By default, the PostgreSQL server is installed in a locked-down state. The server will only listen for connections from the local machine In order to get ThingWorx to communicate to the PostgreSQL server, some configuration changes need to be made so that PostgreSQL knows to listen for connections from other users (thingworx user, default is twadmin) and/or other machines (ThingWorx installed on a separate server).
You will need to know where your PostgreSQL data directory resides for these steps. On Windows, the default data folder is C:\Program Files\PostgreSQL\9.x\data.
Modify the pg_hba.conf file and add the following lines based on your desired configuration:
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
Any other combination is possible by using additional allowance lines (individual IPs or ranges) or subnet masks appropriate to the machines that require access to the PostgreSQL database.
Any change to this file requires a restart of the database service.
* 
For additional information about configuring the pg_hba.conffile, see the official PostgreSQL documentation (9.4).
Configure and Execute the PostgreSQL Database Script
To set up the PostgreSQL database and tablespace, the thingworxPostgresDBSetup script must be configured and executed.
1. Add the <postgres-installation>/bin folder to your system PATH variable.
2. Create a folder named ThingworxPostgresqlStorage on the drive that the ThingworxStorage folder is located (in the root directory by default).
* 
If you create the folder using the -d<databasename> command, you do not have to use the PostgreSQL user.
* 
You must specify the -l option to a path that exists. For example, -l D:\ThingworxPostgresqlStorage. The script does not create the folder for you.
* 
The folder must have appropriate ownership and access rights. It should be owned by the same user who runs the PostgreSQL service, and have Full Control assigned to that user - this user is generally NETWORK_SERVICE, but may differ in your environment.
3. Obtain and open the thingworxPostgresDBSetup script from the ThingWorx software download package. ThingWorx downloads are available in  PTC Software Downloads.
4. If necessary, configure the script. Reference the options in the table below.
5. Execute the script.
thingworxPostgresDBSetup Script Options
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
Configure and Execute the Model/Data Provider Schema Script
To set up the PostgreSQL model/data provider schema, the thingworxPostgresSchemaSetup script must be configured and executed. This will set up the public schema under your database on the PostgreSQL instance installed on the localhost.
1. Obtain the thingworxPostgresSchemaSetup.bat from the ThingWorx software download package. ThingWorx downloads are available in  PTC Software Downloads.
2. If necessary, configure the script. Reference the options in the table below.
3. Execute the script.
thingworxPostgresSchemaSetup Script Options
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
Configure platform-settings.json
1. Create a folder named ThingworxPlatform at the root of the drive where Tomcat was installed or as a system variable.
* 
To specify the location where ThingWorx stores its settings, you can set the THINGWORX_PLATFORM_SETTINGS environment variable to the desired location. Ensure that the folder referenced by THINGWORX_PLATFORM_SETTINGS exists and is writable by the Tomcat user. This environment variable should be configured as part of the system environment variables.
* 
The ThingWorx server will fail to start if it does not have read and write access to this folder.
2. Place the platform-settings.json file into the ThingworxPlatform folder. This file is available in the software download.
3. Open platform-settings.json and configure as necessary. Refer to the configuration options in platform-settings.json Configuration Details.
* 
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. While it is optional to have the PostgreSQL database on the same server as ThingWorx in a development environment, it should be separate in all production environments.
Encrypt the PostgreSQL Password (Optional)
Encrypt the password by following the steps in Encrypting Passwords.
Installing the PostgreSQL Client Package and PostgreSQL User (optional)
In order to issue PostgreSQL commands from the client machine to the PostgreSQL server, do so from a PostgreSQL user. The postgresql-client-9.x package can be installed on the client machine, refer to your distributions documentation on how to install it. This package provides some administration tools such as psql.
Install ThingWorx
Go to Install ThingWorx.