Skip to main content
P
Peter_Raj1-Visitor
1-Visitor
September 30, 2019
Question

Errror in PostgresqlDBsetup

  • September 30, 2019
  • 1 reply
  • 2499 views

Hi

I have installed Postgresql in my local pc and i  am getting the following error in ThingworxPostgresqlDBsetup.bat file and thingworxPostgresSchemaSetup.bat file

Can anyone guide me to rectify this error

 

1 reply

R
raluca_edu17-Peridot
17-Peridot
September 30, 2019

Hi,

 

1. Delete any tablespace created in the location ThingworxBackupStorage; check also in Postgres database to NOT have any datbase called "thingworx" or tabespace called "thingworx"; if any just delete them from database.

2. Run ThingworxPostgresqlDBsetup.bat  with tablespace location  C:/<path_to_location> or C://<path_to_location>

3. After successful ThingworxPostgresqlDBsetup.bat, run also thingworxPostgresSchemaSetup.bat

 

Best regards,

Raluca Edu

P
Peter_Raj1-VisitorAuthor
1-Visitor
September 30, 2019

I followed your steps but I dont find Thingworx on any of the database and Tablespaces 

but still the error apears again

 

 

R
raluca_edu17-Peridot
17-Peridot
September 30, 2019

Hi,

 

Are you executing the script from the path where the script resides?

If not, I recommend to change directory to that path and execute the script again. Also, you need to have psql in environment vars.

 

Best regards,

Raluca Edu

Terms & ConditionsAccessibility statement