Skip to main content
ahawaldar1-Visitor
1-Visitor
July 18, 2017
Question

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

  • July 18, 2017
  • 4 replies
  • 1796 views

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

4 replies

supandey5-Regular Member
5-Regular Member
July 18, 2017

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

ahawaldar1-VisitorAuthor
1-Visitor
July 18, 2017

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

supandey5-Regular Member
5-Regular Member
July 18, 2017

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

Terms & ConditionsAccessibility statement