| From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | issue with remote backup |
| Date: | 2023-10-26 16:51:42 |
| Message-ID: | CA+ONtZ5Cuct0_x6pE=k-8fMPFeBp-i2TBZ-U3=agqadUER2FFA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-10-26 17:15:34 | Re: issue with remote backup |
| Previous Message | Raymond Brinzer | 2023-10-26 15:46:18 | Re: Question regarding the new SQL standard |