重庆思庄Oracle、Redhat认证学习论坛

标题: pg_basebackup报错: failed: FATAL: no pg_hba.conf entry for replication conn [打印本页]

作者: 郑全 时间: 2023-6-9 21:03
标题: pg_basebackup报错: failed: FATAL: no pg_hba.conf entry for replication conn
我们在执行以下命令报错：
$ pg_basebackup -h 192.168.51.82 -D /postgresql/backup/data/$DATE -Ft -Pv -Upostgres -R

pg_basebackup: error: connection to server at "192.168.51.82", port 5432 failed: FATAL:  no pg_hba.conf entry for replication connection from host "192.168.51.82", user "postgres", no encryption
failed to backup

这个通过在pg_hba.conf中加上

host replication    all          192.168.51.0/24       trust

--修改生效
pg_ctl reload

  之后，再去执行备份，就不报错了。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)