issue with remote backup - Mailing list pgsql-general

From Atul Kumar
Subject issue with remote backup
Date
Msg-id CA+ONtZ5Cuct0_x6pE=k-8fMPFeBp-i2TBZ-U3=agqadUER2FFA@mail.gmail.com
Whole thread Raw
Responses Re: issue with remote backup  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: issue with remote backup  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Raymond Brinzer
Date:
Subject: Re: Question regarding the new SQL standard
Next
From: Tom Lane
Date:
Subject: Re: issue with remote backup