Failed to validate the PostgreSQL connection. Please check the information you entered.

[NP_10173733]

I am using ThingWorx Platform Release 8.5

When attempting to install ThingWorx Platform 8.5.4 on a Red Hat Enterprise Linux Server release 7.9 (Maipo) EC2 instance in AWS, I am facing an issue with PostgreSQL validation. The database is running on AWS RDS with PostgreSQL version 15.7. Initially, I was unable to log in to the database manually from this EC2 instance due to SCRAM authentication being set by default. However, after updating to MD5, I am now able to log in to the database via the command line. Despite this, the installation is still failing.

Here are the errors I encountered:

The minimum system requirements for this ThingWorx installation are 4 CPU cores, 16 GB of memory, and 100 GB of disk space on Red Hat/CentOS 7.5 or later. This installer found [4] CPU core(s), [16] GB of memory, and [56] GB of disk space.
There has been an error.
Failed to validate the PostgreSQL connection. Please check the information you entered.

[VladimirN · Accepted solution]

Article - "Getting error "Failed to validate the PostgreSQL connection" when using ThingWorx Installer": https://www.ptc.com/en/support/article/CS275471 

[TonyZhang]

Hi @NP_10173733 ,

It appears that a response to this post answers your question.  For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,