postgresql setup issue

[JOberle]

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.

[JOberle]

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? 

[slangley]

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

[JOberle]

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

[slangley · Accepted solution]

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

[JOberle]

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.

[slangley]

Hi @JOberle 

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

Regards.

--Sharon

[JOberle]

Nevermind. I found it. My screen was being blocked by something weird. Erg. Thanks for the help. This resolves that.

[slangley]

Hi @JJ_9598732.

Glad you found the problem.  If one of the previous responses helped to solve the issue, please mark the appropriate response as the Accepted Solution for the benefit of others with the same issue.

Regards.

--Sharon