Hi,
I have the postgres12 version running on centos7.
In pg_hba.conf file I have an entry like below:
host all all <remote server ip>/32 md5
So from the above entry, I understand that all users can connect to all databases from the remote ip.
But when I use pg_basebackup from remote server using below command I get the below error:
pg_basebackup -h DB_server_hostname -p 5444 -U postgres -D /var/lib/edb/backups/10262023_1 -Fp -Xs -c fast -P
Error that I got:
pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "remote_ip", user "postgres", SSL off
So please help me understand why I am getting this error even after having a related entry in the pg_hba.conf file.
Regards.