Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

[pshashipreetham]

What are the steps that are involved while Upgrading the Postgres DB Schema from the Thingworx 8.4 to 9.3.2 ?

Is there any documentation, where the steps are present for this ?

Thanks,
Shashi.

[pshashipreetham · Accepted solution]

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

1. thingworxPostgresSchemaUpdate.bat
2. thingworxPostgresDBSetupBigIntTimezoneDataUpdate.bat
3. thingworxPostgresModelTablesDataUpdate.bat (Update the sourceTimezone = UTC and targetTimezone = UTC in the bat file)
4. thingworxPostgresStreamSchemaUpdate.bat
5. thingworxPostgresDataTableSchemaUpdate.bat
6. thingworxPostgresValueStreamSchemaUpdate.bat
7. thingworxPostgresDataTableDataUpdate.bat (Update the chunkSize=100000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
8. thingworxPostgresStreamDataUpdate.bat (Update the chunkSize=100000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
9. thingworxPostgresValueStreamDataUpdate.bat (Update the chunkSize=1000000, sourceTimezone = UTC and targetTimezone = UTC in the bat file)
10. 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.