Failed to validate the PostgreSQL connection. Please check the information you entered.
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.

