Skip to main content
A
A.Asir1-Visitor
1-Visitor
December 1, 2020
Solved

Thingworx 8.4 PostgreSql installation error

  • December 1, 2020
  • 1 reply
  • 2354 views

Hi

I have the same problem, how can I fix it? 

C:\Users\TwxAdministrator\Downloads\MED-61111-CD-084_SP14_ThingWorx-Platform-Postgres-8-4-14\install>thingworxPostgresDBSetup.bat
Server=localhost
Port=5432
Database=thingworx
Tablespace=thingworx
Tablespace Location=/ThingworxPostgresqlStorage
Admin User=postgres
Thingworx User=twadmin
Azure Managed Instance=""
Start Execution
Password for user postgres:
psql:./thingworx-database-setup.sql:1: ERROR: role "twadmin" does not exist
psql:./thingworx-database-setup.sql:3: ERROR: tablespace "thingworx" does not exist
psql:./thingworx-database-setup.sql:5: ERROR: tablespace "thingworx" does not exist
psql:./thingworx-database-setup.sql:14: ERROR: role "twadmin" does not exist
psql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not exist
Press any key to continue . . .

Best answer by slangley

Hi @A.Asir.

 

Please refer to these instructions in the ThingWorx Help Center for setting up the thingworx database and twadmin user in PostgreSQL.  Also, in the DBsetup script, change the Tablespace Location to an absolute path.  For example:

 

Tablespace Location=C:\ThingworxPostgresqlStorage

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity ManagerAnswer
Support
December 1, 2020

Hi @A.Asir.

 

Please refer to these instructions in the ThingWorx Help Center for setting up the thingworx database and twadmin user in PostgreSQL.  Also, in the DBsetup script, change the Tablespace Location to an absolute path.  For example:

 

Tablespace Location=C:\ThingworxPostgresqlStorage

 

Regards.

 

--Sharon

    A
    A.Asir1-VisitorAuthor
    1-Visitor
    December 2, 2020

    Hi @slangley 

    Thank you for your time! 

     

    I have now received a new error message. Could you help me with that. 

     

    psql: error: could not connect to server: connection refused (0x0000274d/10061) is the server running on host "localhost" (::1) and accepting tcp/ip connections on port 5432? could not connect to server: connection refused (0x0000274d/10061) is the server running on host "localhost" (127.0.0.1) and accepting tcp/ip connections on port 5432? press any key to continue . . .

     

     

    Best Regards 

     

    Terms & ConditionsAccessibility statement