Skip to main content
14-Alexandrite
March 3, 2020
Solved

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

  • March 3, 2020
  • 5 replies
  • 2041 views

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?

Best answer by slangley

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

5 replies

20-Turquoise
March 3, 2020

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

eyli14-AlexandriteAuthor
14-Alexandrite
March 4, 2020

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?

eyli14-AlexandriteAuthor
14-Alexandrite
March 5, 2020

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"