This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

postgres base backup/ replication from master to standby server

Posted on 01-10-2017 11:03 AM
Not applicable
Reply posted on --/--/---- --:-- AM

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?

0 3 2,936
Topic Labels
0 Likes
3 REPLIES 3
Top Solution Authors
View all