Skip to main content
Best answer by jdass

Are you able to connect to ThingWorx database running on PostgreSQL via PgAdmin III tool?

Can you check that the username and password you use to connect to postgres through pgAdmin are the same as in the paltform-setting.json, that is username twadmin, password: password ... if not please update the platform-settings.json

6 replies

13-Aquamarine
August 29, 2017

Hi Akshayakumar,

Could you please reply in the same thread , as it will be much easier for us to help you solve the issue . And your application log says "Connections could not be acquired from the underlying database". Did you face any issues while running the thingworxPostgresDBsetup.bat ?

jdass13-AquamarineAnswer
13-Aquamarine
August 29, 2017

Are you able to connect to ThingWorx database running on PostgreSQL via PgAdmin III tool?

Can you check that the username and password you use to connect to postgres through pgAdmin are the same as in the paltform-setting.json, that is username twadmin, password: password ... if not please update the platform-settings.json

1-Visitor
August 30, 2017

Thank you sir, the password which i have given in Pgadmin tool is not same as Json file. now i have changed, working properly..Thank you so much

17-Peridot
August 29, 2017

Hi Akshayakumar,

Could you please share your platform-settings.json file which is located in /ThingworxPlatform folder? Also, I would suggest you to provide full control access to the user for /ThingworxPlatform, /ThingworxStorage and /ThingworxPostgreSQLStorage folders.