Search Postgresql Archives

issue with remote backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux