I am trying to set up SSPI for PostgreSQL 16 DB. I have edited the pg_ident.conf & pg_hba.conf
pg_ident.conf
MAPNAME SYSTEM-USERNAME PG-USERNAME
Mapname accountname@domainname accountname
pg_hba.conf
TYPE DATABASE USER ADDRESS METHOD
host all accountname 127.0.0.1/32 sspi map=Mapname host all accountname ::1/128 sspi map=Mapname
After restarting the service SSPI does not work. From the trouble shooting it seems that the SSPI entries on the pg_hba.conf is not recognised at all.
When all other entries are commented I get the error - connection failed: :1), port 5432 failed: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", no encryption
Can any body advice? If I am missing something?