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 CAMcqKmnO3BgLFCQCjW4TxstBd9R+Mj1goAaTHkjPMZWR3QbjaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: no pg_hba.conf entry for replication connection from host  (Volkan Unsal <spocksplanet@gmail.com>)
Ответы Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
I set up logging for connections. Here is what I see:

LOG:  connection received: host=104.131.66.183 port=38912
LOG:  replication connection authorized: user=postgres
LOG:  connection received: host=104.131.66.183 port=38913
LOG:  replication connection authorized: user=postgres

Two connection attempts are made. First is probably for pg_basebackup. The second might be for streaming replication. If it's true, then I don't understand why it is not succeeding...


On Thu, Apr 9, 2015 at 5:22 PM, Volkan Unsal <spocksplanet@gmail.com> wrote:

 Not sure that is a problem as the logs show the database reaching a consistent state:

But the database doesn't open a port after reaching this state. Hence, when I nmap the IP address of the standby server, I don't see an open port for postgresql. Is that normal?

Also setting up logging connects/disconnects on the primary to see if an attempt is even being made.

How would I set this up? I think I'm already seeing failed connection attempts since they raise FATAL errors, but maybe I'm not seeing successful connection attempts. 



--
Volkan Unsal
web and mobile development



--
Volkan Unsal
web and mobile development

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host