Skip to main content
J
JOberle1-Visitor
1-Visitor
March 18, 2021
Solved

postgresql setup issue

  • March 18, 2021
  • 2 replies
  • 2747 views

I am on page 29 of the installing thingworx pdf. I run the batch file, ThingworxPostgresDBSetup, enter my password, and I get this...

 

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 . . .

 

I found instruction on how to fix this in pgAdmin3 but I have pgAdmin4 and the instructions make no sense. I am guessing pgAdmin4 is different. I cannot figure out how to configure the script to not get these errors.

Best answer by slangley

Hi @JOberle.

 

Without knowing which version of ThingWorx you are installing or the platform you're running on, here is the link to the ThingWorx 9.x manual setup instructions for PostgreSQL on Windows.   If this isn't the correct configuration for your needs, you can use the panel to the left for navigating to the appropriate section.  Note that the database user account (step 4) has to exist before running the scripts.

 

We also have installers available which may be easier to use but these require that both the database user and database instance be created prior to running the installer.  Here is a link to the instructions.

 

Regards.

 

--Sharon

2 replies

J
JOberle1-VisitorAuthor
1-Visitor
March 18, 2021

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FInstallation%2FInstallation%2Finstall_and_configure_postgresql_windows.html%23

 

 

I found this during my search before I posted but number 4 line a is confusing. I do not see anything to right click. What screen is this on? 

S
slangleyCommunity Manager
Community Manager
March 18, 2021

Hi @JOberle.

 

I was working on my response to your original post and didn't see your follow up response until I had posted mine. 

 

To answer your question, it's referring to right-clicking Postgres in pgAdmin to pull up the menu for creating the user

 

Regards.

 

--Sharon

J
JOberle1-VisitorAuthor
1-Visitor
March 18, 2021

I do not see this anywhere. Where on the screen is it. I feel like I am missing something. 

S
slangleyCommunity ManagerAnswer
Community Manager
March 18, 2021

Hi @JOberle.

 

Without knowing which version of ThingWorx you are installing or the platform you're running on, here is the link to the ThingWorx 9.x manual setup instructions for PostgreSQL on Windows.   If this isn't the correct configuration for your needs, you can use the panel to the left for navigating to the appropriate section.  Note that the database user account (step 4) has to exist before running the scripts.

 

We also have installers available which may be easier to use but these require that both the database user and database instance be created prior to running the installer.  Here is a link to the instructions.

 

Regards.

 

--Sharon

J
JOberle1-VisitorAuthor
1-Visitor
March 18, 2021

Thanks for the reply. It is thingworx 8 on a seperate server. The line I am having issue with is this...

 

a. Right click PostgreSQLx.x (<IP or host name of the database>:<Port number of PostgreSQL>). Example: PostgreSQLx.x (localhost:5432)

 

I cannot find this anywhere. Where is this located? I would love to right click it but I cannot find it.

S
slangleyCommunity Manager
Community Manager
March 18, 2021

Hi @JOberle 

 

Give me some time to get PostgreSQL installed, and I will send a screenshot.

 

Regards.

 

--Sharon

Terms & ConditionsCookie settingsAccessibility statement