Guidance Needed for Switching ThingWorx Database to a New Postgres Instance

Hi ThingWorx Community,

I’m currently running ThingWorx version 9 (ThingWorx development.server.build-b12466) with a Postgres database. I want to switch to a new Postgres database hosted on RDS.

Here’s what I’ve done so far:

1. Created a new RDS instance.

2. Added a database named thingworx.

3. Updated the platform-settings.json file with the new database connection details.

However, when I start ThingWorx, I encounter the following error:

I’m trying to understand:

• Is updating the platform-settings.json file the correct method to point to a new Postgres database?

• Are there additional steps I need to perform to migrate ThingWorx to a new database instance?

• Could this error indicate a problem with the database setup, migration, or connection configuration?

Any guidance or recommended steps for safely switching the database would be greatly appreciated.

Thanks in advance!