FATAL: no pg_hba.conf, node 5 of 5-node system

samuelucich
Participant IV

Hi,

I'm trying to spin up a 5-node architecture on-prem 4.18.01, hosted on GCP.

Made it through the first 4 nodes, but node 5 is giving me an issue. Looks like Node 5 is the Standby Analytics server for this system. When I run the install, i see this at the end, please advise:

Service setup apigee-postgresql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.vwtonline.net
 * epel: mirror.us.leaseweb.net
 * extras: mirror.math.princeton.edu
 * updates: mirror.cs.vt.edu
No packages marked for update
Validating setup variables
Checking for required variables
Checking required variable HOSTIP...OK
Checking required variable RUN_USER...OK
Checking required variable RUN_GROUP...OK
Checking for optional variables
Found optional variable PG_MASTER...OK
Found optional variable PG_STANDBY...OK
This node is configured as Slave, hence adding slave telegraf templates
/opt/apigee/apigee-postgresql-9.6.1-0.0.1132/lib/actions/setup: line 23: /opt/apigee/apigee-postgresql-9.6.1-0.0.1132/metrics/telegraf_slave_template.toml: No such file or directory
/opt/apigee/apigee-postgresql-9.6.1-0.0.1132/lib/actions/setup: line 23: /opt/apigee/apigee-postgresql-9.6.1-0.0.1132/metrics/telegraf.toml: No such file or directory
apigee-service: apigee-postgresql: Not running (NO_PIDFILE)
apigee-service: apigee-postgresql: Not running (NO_PIDFILE)
connection to postgres master successful. Proceeding with replication setup on standby
apigee-service: apigee-postgresql: Not running (NO_PIDFILE)
pg_basebackup: could not connect to server: FATAL:  no pg_hba.conf entry for replication connection from host "10.142.0.6", user "apigee", SSL off
Error: setup.sh: /opt/apigee/apigee-service/bin/apigee-service exited with unexpected status 1
0 3 741
3 REPLIES 3

Getting same error trying to set up a new 5 node cluster using AWS Linux. I didn't see any answers but figured I'd check with you to see if you figured out the issue. Appreciate it.

Thanks.

ElangoD
Participant III

Hi,

I faced Same Issue,

In the config file add both PG_Master and PG_Slave ip

From Master Node run "/opt/apigee/apigee-service/bin/apigee-service apigee-postgresql setup-replication-on-master -f config.properties"

which will add in "pg_hba.conf" with host replication apigee xx.xxx.xxx.xx/32 trust

After this continue Installation in Slave Node .

worked for me thenaks