Re: Help needed for replication issue

Hi Ashok!

On Sun, Apr 26, 2020 at 8:22 AM Ashok kumar Mani <amani(at)accelaero(dot)com>
wrote:

> Classification: Internal
>
>
>
> Dear All
>
> I am getting this below error during hot standby configuration .
>
>
>
> Please help
>
> [postgres(at)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(at)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
--
Olivier Gautherot
https://www.linkedin.com/in/ogautherot/

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>