Error installing Analytics-on-Premise when generating database for datastore

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

While installing Analytics-on-Premise datastore, after successfully installed Postgre SQL, user cannot create user and database for Postgres with provided setup.psql

Error messages:

C:\Program Files\PostgreSQL\9.4\bin>psql -h hostname -p 5433 -U postgres -v username="uc4analytic" -v password="'******'" -v db_name="uctpostgre" -f C:\automic\datastore\setup.psql
psql: FATAL: no pg_hba.conf entry for host "x.x.x.x", user "postgres", database "postgres", SSL off

 

Environment

Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Component:

Cause

This is a general error with postgre where the PostgreSQL Client Authentication Configuration File(..\PostgreSQL\<version>\data\pg_hba.conf) does not contain corresponding entry

Resolution

Solution is to add the following entry to the PostgreSQL Client Authentication Configuration File(..\PostgreSQL\<version>\data\pg_hba.conf):
 

# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 md5

(it will allows all connections from any hosts)

then restart your postgreSQL before continue with the process

Other workaround: The original setup only allows local connections, so another fix could be replacing your hostname.domain with the localhost or it's local name/ip (if Postgre was installed on the same local host)

Additional Information

https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#Analytics/Aaas_setup_datastore_windows.htm%3FTocPath%3DInstallation%2520Guide%7CInstalling%2520Analytics%2520(ANOP)%7CNew%2520Installation%2520and%2520Configuration%7CManual%2520Installation%7CInstalling%2520the%2520Datastore%7C_____1