Azure PostgreSQL - Thingworx 9.3.9

[Sathishkumar_C]

We are trying to setup a Thingworx server with Azure PostgreSQL services.

Reffered few articles. 

• ThingWorx installer fails to connect to an Azure PostgreSQL database
• ThingWorx installation fails on Azure PostgreSQL

Here it says, Thingworx Foundation Installer is not supported on Azure PostgreSQL.

Is that possible to setup a Thingworx with Azure PostgreSQL in manual mode of installation (without installer)?

[PaiChung]

Even though the installer isn't able to do it, you can do this manually.

You may run into some issues running the database creation/schema scripts, but if you can execute those directly within the database itself (using management studio for example), you shouldn't have an issue.

[slangley · Accepted solution]

Hi @Sathishkumar_C 

If you are referring to a managed PostgreSQL db instance, then it's currently not supported.  Support will be added for this in the future.  In the meantime, you will have to install PostgreSQL manually and manage it yourself.

Regards.

--Sharon

[Sathishkumar_C]

@PaiChung 

So, Thingworx 9.3.9 will support with Azure Managed PostgreSQL. Thank you.

@slangley 

We are okay with installing PostgreSQL and managing it. But, we need to keep it another VM so it will increase environment cost.