postgres base backup/ replication from master to standby server

[#1]

Hello All,

I'm trying to take a full base backup of postgres database from master to standby. Postgres pg_hba.conf file is configured with "test" user for replication.

I've followed "http://docs.apigee.com/private-cloud/latest/set-master-standby-replication-postgres" apigee recommendation to setup master-standby. But while executing "/opt/apigee/apigee-service/bin/apigee-service apigee-postgresql setup-replication-on-standby -f configFile", I'm getting the below error.

apigee-service: apigee-postgresql: Not running (NO_LOCKFILE) pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry for replication connection from host "30.135.211.50", user "apigee", SSL off

Any pointer?

[atoombs]

Hi @sankar.sekar,

In this situation, you will need to manually update the pg_hba.conf file as per the following:

http://docs.apigee.com/private-cloud/latest/update-apigee-edge-4160141605-41701#requiredupgradetopos...

Specifically, this:

host replication apigee existing_slave_ip/32 trust 
host replication apigee new_slave_ip/32 trust 

I hope this helps. Thanks!

[samuelucich]

that link throws a 404

[sgilson]

This is the correct link:

https://docs.apigee.com/private-cloud/v4.17.01/update-apigee-edge-4160141605-41701#requiredupgradeto...Stephen