Re: Help needed for replication issue - Mailing list pgsql-admin
Hi Ashok!
On Sun, Apr 26, 2020 at 8:22 AM Ashok kumar Mani <amani@accelaero.com> wrote:
Classification: Internal
Dear All
I am getting this below error during hot standby configuration .
Please help
[postgres@de284194 ~]$ pg_basebackup --host='172.28.4.194' --port=5432 --username=postgres --pgdata=/backup/standby
pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry for replication connection from host "172.28.4.194", user "postgres", SSL off
pg_basebackup: removing contents of data directory "/backup/standby"
[postgres@de284194 ~]$
Just follow the instructions in the message: you need to add a line to pg_hba.conf. This is the file that controls the accesses to the database. It may be located in your data directory (/backup/standby) or in other places, depending on your system (by default, Ubuntu places this file by default in /etc/postgresql/...).
If you need more support, remember to state the OS and PG version.
Hope it helps
pgsql-admin by date: