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?
