Skip to main content
1-Visitor
March 9, 2020
Question

Not able to start postgre sql

  • March 9, 2020
  • 21 replies
  • 5975 views

I am not able to start my postgre sql. when I attempt to start, it stops immediately. Also, my "ThingworxPostgresqlStorage" folder is taking 198 Gb  space out of 250 Gb. Because of this my "C drive" goes full. I tried removing some files from this folder and attempted to start "postgresql serviece". But, again "ThingworxPostgresqlStorage" folder is taking lots of space. I am using Thingworx version 8.4. What is the solution for this ?

21 replies

raluca_edu
17-Peridot
March 9, 2020

Hi,

 

We need more info on Thingworx side:

- exact version: 8.4.x

- it is a new installation?

- attach ThingworxStorage/logs, Tomcat logs, Postgres logs.

 

Thanks,

Raluca Edu

1-Visitor
March 10, 2020

It is not a new installation.

Since composer is not opening, can you tell me how to check the version of thingworx?

Attaching the current logs of Tomcat

16-Pearl
March 10, 2020

@sanjanabalaji,

 

If the database Postgresql could not be started, Thingworx could not be started also.

The below log files will be useful to understand the issue:

1) Postgresql's log

2) Tomcat's catalina.<TimeStamp>.log.

3) Thingworx's log flies under <ThingworxStorage>/logs. It will be helpful to generate fresh log files after backup and delete the old log files and restart Thingworx.

 

Tomcat's localhost and manager log files are not useful for this kind of case.