Replication using mTLS issue

Поиск
Список
Период
Сортировка
От Drew Zoellner
Тема Replication using mTLS issue
Дата
Msg-id CAGWxRFfWbD3NNJcpiPA6+g+UYRHAmD6Z4+rQaHoNi5+EEt1gOg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Replication using mTLS issue
Список pgsql-general
Hi Postgres team, I’m receiving an issue matching pg_hba rules that I can’t seem to sort out. I am trying to use mtls certificate authentication for physical replication connections but keep receiving the following error…

pg_receivewal: error: FATAL:  no pg_hba.conf entry for replication connection from host "100.84.12.223", user "pgrepmgr_nonprod", SSL on


My pg_hba.conf file contains

	hostssl replication pgrepmgr_nonprod 100.0.0.0/8 cert map=pgrepmgr_nonprod_map

I’ve made sure the rule comes first in my pg_hba.conf file or last. I’ve read the pg_hba documentation fully and tried with all values for hostssl field, user field and ip field. Still no luck.
Is cert authentication supported for replication connections?

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgresql python in upgraded version 16.2
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Transaction issue