Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

pshashipreetham — Thu, 23 Jun 2022 19:26:11 GMT

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.

Re: Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

pshashipreetham — Thu, 23 Jun 2022 18:14:38 GMT

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.

topic Re: Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2 in ThingWorx Developers

Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2

Re: Upgrading the Postgres DB Schema from Thingworx 8.4 to 9.3.2