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


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