Re: no pg_hba.conf entry for replication connection from host

Поиск
Список
Период
Сортировка
От Volkan Unsal
Тема Re: no pg_hba.conf entry for replication connection from host
Дата
Msg-id CAMcqKmkhk-85fwve+DTZp1vH-M=ETmhuMY+dgLSYWMGHnwt0mA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: no pg_hba.conf entry for replication connection from host  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: no pg_hba.conf entry for replication connection from host  (Melvin Davidson <melvin6925@gmail.com>)
Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Hi Melvin,

I followed your instructions above and modified the pg_hba.conf in master to hardcode the IP address of the standby server. I kept the same pg_hba.conf file for the standby server –– I hope that was right. The log output hasn't changed much, but I'm enclosing it in this gist:


I hope the answer is in there...



On Fri, Apr 10, 2015 at 9:28 AM, Melvin Davidson <melvin6925@gmail.com> wrote:
Volkan,

What I see in the link is the original post.
I did not see any postgres log entry complaining about invalid entry in pg_hba.conf.

The pg_hba.conf entry in your original post is wrong. What you need is

host    replication     replication     104.131.66.183/32        md5

If you get an error after making that change, then please attach the complete new
version of the pg_hba.conf AND the entry from postgres log where it complains about
the invalid or non pg_hba.conf entry.




--
Volkan Unsal
web and mobile development

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Background worker assistance & review
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host