Thingworx 8.3 PostgreSql installation error

[isha]

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
.

[vangne]

@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

[vangne · Accepted solution]

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