On windows 2016 in AD setup when I try to use SSPI with postgresql 11 and following settings :
host all all 127.0.0.1/32 sspi map=newmap #IP4
newmap SrvSupportPsgr srvsupportpsgr
Log: no match in usermap "newmap" for user "SrvSupportPsgr" authenticated as "SrvSupportPsgr@domainname"
FATAL: SSPI authentication failed for user "SrvSupportPsgr"
this account has superuser on postgres and local admin + domain user on AD. I have tried putting usernames in double quotes as well. thanks