Found it...
Steps to Upgrade the Postgres DB from Thingworx 8.4 to 9.3.2
Step 1: Run Only thingworxPostgresSchemaUpdate8.4-to-8.5.bat for 8.4.3 to 8.5
Step 2: from 8.5 to 9.0 Run the Following Scripts
Note: The following bat files can be found only in the 9.0.0 Software Download File and run the following bat files in order
- thingworxPostgresSchemaUpdate.bat
- thingworxPostgresDBSetupBigIntTimezoneDataUpdate.bat
- thingworxPostgresModelTablesDataUpdate.bat (Update the sourceTimezone = UTC and targetTimezone = UTC in the bat file)
- thingworxPostgresStreamSchemaUpdate.bat
- thingworxPostgresDataTableSchemaUpdate.bat
- thingworxPostgresValueStreamSchemaUpdate.bat
- thingworxPostgresDataTableDataUpdate.bat (Update the chunkSize=100000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
- thingworxPostgresStreamDataUpdate.bat (Update the chunkSize=100000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
- thingworxPostgresValueStreamDataUpdate.bat (Update the chunkSize=1000000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
- thingworxPostgresDBCleanupBigIntTimezoneDataUpdate.bat
Step 3: 9.0 to 9.1 is not needed
Step 4: 9.1 to 9.2 run thingworxPostgresSchemaUpdate9.1-to-9.2.bat
Step 5: 9.2 to 9.3 run thingworxPostgresSchemaUpdate9.2-to-9.3.bat
Help Doc:
https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Installation/Installation/manual_inplace_upgrade_windows.html#
Thanks,
Shashi.