Skip to main content
S
SamuelRodrigues1-Visitor
1-Visitor
January 15, 2019
Solved

I'm getting an error while running thingworxPostgresDBSetup.bat

  • January 15, 2019
  • 1 reply
  • 4420 views

When I run the thingworxPostgresDBSetup.bat script, I am getting the following error:

 

psql:./thingworx-database-setup.sql:14: ERROR: could not create directory "pg_tblspc/16404/PG_9.4_201409291/16405": No such file or directory
psql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not exist
Pressione qualquer tecla para continuar. . .

 

 

Best answer by slangley

Hi @SamuelRodrigues.

 

I just wanted to update this post with the solution we found while working the case.

 

We found that the thingworx tablespace already existed, so it was deleted.  In addition, the path was updated for the tablespace location in thingworxPostgresDBSetup.bat.  The script was then run from the command line as follows:  thingworxPostgresDBSetup –a postgres –u twadmin –l C:\ThingworxPostgresqlStorage

 

The script then ran successfully and we were able to proceed with the next step of the installation per the guide.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity Manager
Support
January 15, 2019

Hi @SamuelRodrigues.

 

On which platform are you installing (Windows, Linux, etc.)?

 

The error indicates the script is unable to create the needed folder structure, which could indicate a permissions issue.  Did you create a folder called ThingworxPostgresqlStorage?

 

It would also be helpful to know which ThingWorx version you are installing.  The installation instructions for all versions can be found here.

 

Regards.

 

--Sharon

S
SamuelRodrigues1-VisitorAuthor
1-Visitor
January 15, 2019

Hello, I'm using Windows Server 2016, the thingworx has not yet been installed. I'm in the bdd creation stage at Postgre. Is it necessary to install the thingworx first?
The "ThingworxPostgresqlStorage" folder is created, with all active permissions, and the Windwos firewall is disabled.

S
slangleyCommunity Manager
Support
January 15, 2019

Hi @SamuelRodrigues.

 

I would recommend opening a case or I will be happy to open one on your behalf.  Since you are running into several different issues, that might be the quickest way to address them.

 

Please let me know if that would be an acceptable way to proceed, and if so, whether you plan to open the case or would prefer me to do so.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement