Skip to main content
1-Visitor
September 26, 2019
Solved

Thingworx 8.3 PostgreSql installation error

  • September 26, 2019
  • 1 reply
  • 1827 views

On running thingworxPostgresDBSetup i am getting following error.

psql:./thingworx-database-setup.sql:1: ERROR: role "twadmin" does not exist
psql:./thingworx-database-setup.sql:3: ERROR: tablespace "thingworx" does not e
xist
psql:./thingworx-database-setup.sql:5: ERROR: tablespace "thingworx" does not e
xist
psql:./thingworx-database-setup.sql:14: ERROR: role "twadmin" does not exist
psql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not ex
ist
Press any key to continue . . .
End Execution
.

Best answer by vangne

Hi @isha, If your issue is resolved, please post it here and mark it as the Accepted Solution for the benefit of others on the community.

 

-Vibhuti

1 reply

16-Pearl
September 26, 2019

@isha

Per error, twadmin user does not exist/not created.

 

Can you please check/confirm that a user role as twadmin was created using pgadmin tool in your Postgres database(on page 25 of the installation guide)?

 

If not, then you will need to create the user role twadmin manually before running the scripts.

 

Also, you may refer to this article for more information.

 

Thanks,

Vibhuti

vangne16-PearlAnswer
16-Pearl
September 27, 2019

Hi @isha, If your issue is resolved, please post it here and mark it as the Accepted Solution for the benefit of others on the community.

 

-Vibhuti