Monday 9 March 2020

pg_basebackup : could not connect to server: FATAL: no pg_hba.conf entry for replication connection


pg_basebackup: could not connect to server: FATAL:  no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off







-bash-4.1$ vi $PGDATA/pg_hba.conf

Add the following line in the bottom of pg_hba.conf:

#local   replication     postgres                                trust
host    replication     postgres        127.0.0.1/32            trust


Add/modify the line in postgresql.conf:

listen_addresses = '*'

now reload the config






No comments:

Post a Comment