and if it is an issue with 9.6, I will fully remove 9.6 and install 9.4 instead. I'am waiting / database thinhworx doesn't exist error
You could try deleting "PG_9.####" folder in ThingworxPostgresqlStorage and running the bat files again for the error.
thingworxPostgresDBsetup.bat file creates thingworx database and tablespace. So no need of creating them manually. Please let me know if they are not created automatically after running those .bat files.
Thanks Yamini but I can't run those .bat files, I begin with the :
- thingworxPostgresDBSetup.bat :
-- I have give all rights to twadmin, see image joined,
-- I have add the line with twadmin in the .bat :
REM Run psql
psql.exe -q -h %server% -d postgres -U %adminusername% -p %port% -v database=%database% -v tablespace=%tablespace% -v username=%thingworxusername% -v tablespace_location=%tablespace_location% -f ./thingworx-database-setup.sql
thingworxpostgresDBSetup –a postgres –u twadmin –l C:\ThingworxPostgresqlStorage
See file joined
-- and I obtained password authenticatin erro, see file joined at the execution
thanks for your help
Please make sure that you are using the postgres super-user password (created while installing PostgreSQL) when prompted to enter the password. To find the postgres user password:
Here are the steps I need you to follow:
run the thingworxPostgresDBCleanup script file. : the DB thingwors doesn't exist
The thingworx tablespace doesn't exist
Run the DBsetup : same thing
Try updating the Tablespace Location value in the PostgresDBSetup.bat file to the corresponding location. For example, if you've created directory in C drive then update it as C:\ThingworxPostgresqlStorage .