cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

pshashipreetham
17-Peridot

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.

Shashi Preetham
1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

1 REPLY 1

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
Top Tags