Using PostgreSQL as the model data provider
Hi,
I installed Thingworx using twxFoundationH2Trial-8.3.2-linux-x64-installer.run and I'm trying to make it use Postgresql as the model provider. I edited platform-settings.json to point to postgresql but it seems to have no effect. I have Postgresql installed and configured on a different machine and the storage folder is /ThingworxPostgresqlStorage. I can telnet port 5432 from Thingworx machine and I have run the scripts thingworxPostgresDBSetup.sh and thingworxPostgresSchemaSetup.sh and I can see the schema and all the tables created in Postgresql
platform-settings.json
{
"PlatformSettingsConfig": {
"BasicSettings": {
"InternalAesCryptographicKeyLength": 128,
"BackupStorage": "/opt/twxFoundationH2Trial-8.3.2/tomcat/apache-tomcat-8.5.23/ThingworxBackupStorage",
"DatabaseLogRetentionPolicy": 7,
"EnableBackup": true,
"EnableHA": false,
"EnableSystemLogging": true,
"HTTPRequestHeaderMaxLength": 2000,
"HTTPRequestParameterMaxLength": 2000,
"Storage": "/opt/twxFoundationH2Trial-8.3.2/tomcat/apache-tomcat-8.5.23/ThingworxStorage"
},
"AdministratorUserSettings": {
"InitialPassword": "<password>"
}
},
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://10.6.0.33:5432/thingworx",
"password": "<password>",
"username": "twadmin"
}
}
}
}
