I was able to set up posgres for thingworx. I see thingworx specific database and tables are created in postgres db.

[ahawaldar]

Hello Sushant Pandey​,

Good Day.

I was able to set up posgres for thingworx. I see thingworx specific database and tables are created in postgres db. However when I start the tomcat, I see that H2 database is still being used instead of postgres. What setting I have missed here. Below is the platform-settings.json file content

{

"PersistenceProviderPackageConfigs": {

"PostgresPersistenceProviderPackage": {

"ConnectionInformation": {

"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

"password": "password",

"username": "twadmin"

}

}

}

}

Thanks,

Azim

[supandey]

Hi Azim, did you migrate your TWX from H2 to Postgresql? or was this a new installation? You'll have to ensure that you are using the right distribution package i.e. the ThingWorx war for Postgresql

[ahawaldar]

Hi Sushant Pandey​,

I am using the existing distribution package which was earlier using H2. Can't I use this package for Postgres DB?

Thanks,

Azim

[supandey]

Hey Azim, no it's important you use the correct corresponding PersistenceProvider package. So if earlier you were using H2 you will have to migrate all of your data to the PostgreSQL. For that you can refer to the guide concerning the Upgrade to ThingWorx

[ahawaldar]

Thanks Sushant Pandey​. This helped me.