ThingWorx Platform PostgreSQL Installer fails with "Connections could not be acquired from the underlying database" when trying to start Apache Tomcat for the first time

• ThingWorx Platform PostgreSQL Installer validates the database connection but fails to start after install
• ThingWorx Platform installer fails to complete due to a PostgreSQL database connection issue but the connection is validated during the install
• ThingWorx Platform database tables are created successfully but the Installer fails to start ThingWorx Platform citing a database connection error
• ThingWorx Platform Installer successfully connects to the database, bypassing the database connection details dialog but fails at the very end of the install process
• ThingWorx Platform does not start citing a database connection error even though the connection is valid and the database tables are created
• Connecting to the database via psql in Command Prompt or Terminal works but ThingWorx Platform still fails to complete the install with database connection errors
• PostgreSQL database installed on the same host as ThingWorx Platform, connections seem to be made from different IP Addresses (loopback, non-loopback) depending on where the connection is being created from
• ThingWorx Platform Installer hangs at Waiting for ThingWorx Foundation...
• ThingWorx Platform install times out waiting for ThingWorx to become accessible
• ThingWorx Foundation installer failing with error:

• <Temp>\ThingWorxFoundation_Failed_installs\ThingWorxFoundation_install.log shows the following:

Wait 560s for /\[[^\]]+Thingworx.war\][^\n]*\[[^\]]+\]/ in "<ThingWorx Install>tomcat\current\logs\thingworx-foundation-stderr.2021-11-17.log"
waiting 5s
...
"" found in "<ThingWorx Install>tomcat\current\logs\thingworx-foundation-stderr.<Date>.log"
Step twxIsRunning script failed  :: 0

• <Temp>/ThingWorxFoundation_Failed_installs/foundation_platform/ApplicationLog.log shows the following:

[L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->zp0w2ealdavx1z1t5ntn2|402a0031]-HelperThread-#0] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7b569be1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
[L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->zp0w2ealdavx1z1t5ntn2|402a0031]-HelperThread-#0] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@24fec6d9 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Connections could not be acquired from the underlying database!
[L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
[L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] >>>>>>> PLATFORM SHUTDOWN START <<<<<<<<<