Postgres Pro
Downloads
Home   >   mailing lists

Replication using mTLS issue - Mailing list pgsql-general

From Drew Zoellner
Subject Replication using mTLS issue
Date
Msg-id CAGWxRFfWbD3NNJcpiPA6+g+UYRHAmD6Z4+rQaHoNi5+EEt1gOg@mail.gmail.com
Whole thread Raw
Responses Re: Replication using mTLS issue
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgresql python in upgraded version 16.2
Next
From: Rich Shepard
Date:
Subject: Re: Transaction issue