FATAL: no pg_hba.conf entry for host
Pega 7.4 is installed on the AWS Cloud environment and the database configured is AWS Relational Database Services (RDS) PostgreSQL 9.6.3. The schema is created using Data Definition Language (DDL) scripts. However, error occurs and install.sh script fails.
/app/Pega/scripts/setupDatabase.xml:1467: Failed to connect using provided properties. FATAL: no pg_hba.conf entry for host "127.0.0.1", user "pega_cloud_stg_master", database "pega_cloud_stg_master", SSL off
Steps to Reproduce
- Provision AWS PostgreSQL 9.6.3 RDS.
- Install Pega 7.4 application using the install.sh script.
This behavior is as per Pega product design.
Here's the explanation for the reported behavior:
PostgreSQL parameters are required for setupDatabase.properties used by the install.sh script in an AWS environment. AWS does not manually update the pg_hba.conf file as outlined in the Pega 7.4 Installation Guide. Additionally, SSL must be reenabled.
Update the setupDatabase.properties file as below.
0% found this useful