Can I install PostgreSQL 12 after Thingworx for Manufacturing 8.4 has been installed?

[eyli]

I had installed Thingworx for Manufacutring 8.4. I found "C:\PTC\ThingworxManufacturingApps\PostgreSQL" this directory on the server. Looks like PostgreSQL was installed by Thingworx for Manufacturing. I'd like to use PostgreSQL as data persistence provider. Can I install PostgreSQL 12 again? or Can I just use the existing one?

[posipova]

You can use the existing ones, but note postgresql 12 is not supported.

[eyli]

Thanks for your answer. I tried by opening the pgAdmin4 and browser opened saying I have no privilege to access the PostgreSQL installed by Thingworx for Manufacturing. How should I do?

[eyli]

Maybe I need to create another instance of PostgreSQL as described in  "https://stackoverflow.com/questions/39842725/postgresql-how-to-create-two-instances-in-same-window-machine"

[slangley · Accepted solution]

Hi @eyli.

So the problem you're having is that you don't know the password for the thingworx db user in PostgreSQL?  This password would have been created at the time you ran the installer.  If you don't remember it, you can reinstall using the foundation installer, but this will require that all existing components be removed first or you will encounter errors. Another option is to install a separate supported version of PostgreSQL, but you would then need to complete the manual install process.

Please let us know exactly what the issue is and we can recommend the best approach.

Regards.

--Sharon

[eyli]

ok. I will try to recall the password or setup a new instance of PostgreSQL. Thanks for your help. Let's close this ticket.