Skip to main content
pshashipreetham
19-Tanzanite
June 23, 2022
Solved

Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

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
19-Tanzanite
June 23, 2022

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.

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com

1 reply

pshashipreetham
pshashipreetham19-TanzaniteAuthorAnswer
19-Tanzanite
June 23, 2022

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.

Translate
Shashi Preetham || +91 8099838801 || shashi@psptechhub.com