Errror in PostgresqlDBsetup

[Peter_Raj]

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

[raluca_edu]

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

[Peter_Raj]

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

but still the error apears again

[raluca_edu]

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

[Peter_Raj]

The same error comes again

[raluca_edu]

Hi,

Please change tablespace location, open script in edit mode and add the path where you want your tablsespace to be created.

Then run again script.

Best regards,

Raluca Edu