Skip to main content
A
anaclos14-Alexandrite
14-Alexandrite
February 25, 2021
Solved

PostgreSQL Server failed to start

  • February 25, 2021
  • 2 replies
  • 3758 views

Hello. I installed ThingWorxFoundationPostgres-8.5.8-x86_64.run on RHEL. It was working fine and I stopped using it for a while. When I wanted to enter again, the empty Composer appeared and I could not navigate. I saw that the disk was full and I deleted some archived logs, then I restarted tomcat and RHEL server, with which afterwards I could not enter the Composer again. I cannot start the Postgres server. Can anybody help me?

Best answer by slangley

Hi @anaclos.

 

You'll need to resolve the PostgreSQL issue before you can attempt to start ThingWorx.  Recommend checking the PostgreSQL logs to determine why it's not starting.  Once PostgreSQL is up and running again, you can restart Tomcat to see if ThingWorx is coming up.  If not, we'll need new Tomcat and ThingWorx logs in order to assist further.

 

Regards.

 

--Sharon

2 replies

S
suverma14-Alexandrite
14-Alexandrite
February 26, 2021

Hi @anaclos 

 

Can you please attach the Tomcat as well Thingworx logs here to see if any error while starting application.

 

Can you also see if you JAVA version was updated and correct path exist in your Tomcat Java config.

A
anaclos14-AlexandriteAuthor
14-Alexandrite
February 26, 2021

Hi @suverma I am sending the log files. I found an error in the JRE_HOME environment variable that is pointing to the wrong address. I will modify it and let you know if I can solve the problem. Thanks

S
slangleyCommunity ManagerAnswer
Community Manager
February 26, 2021

Hi @anaclos.

 

You'll need to resolve the PostgreSQL issue before you can attempt to start ThingWorx.  Recommend checking the PostgreSQL logs to determine why it's not starting.  Once PostgreSQL is up and running again, you can restart Tomcat to see if ThingWorx is coming up.  If not, we'll need new Tomcat and ThingWorx logs in order to assist further.

 

Regards.

 

--Sharon

A
anaclos14-AlexandriteAuthor
14-Alexandrite
February 26, 2021

Hi, @slangley The problem is that I have a full disk and can't start postgresql. I am sending you a capture of the disk usage where it can be seen that the postgresql base folder is taking up the most space. I don't know if the database can be exported to another instance to reduce its size and then import it again.

diskFull.PNG

S
slangleyCommunity Manager
Community Manager
February 26, 2021

Hi @anaclos.

 

You might review this page from the PostgreSQL web site.  If you decide to run the utility, I recommend creating a server backup first.  You may run into issues running the utility if the space is fully depleted on disk.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement