Re: Q: cert authentication and user remapping fails

2019-12-09 Thread Albrecht Dreß
Sorry for the late reply, I could test your solution only today… Am 06.12.19 18:52 schrieb(en) Tom Lane: I don't think that the user name mapping feature works in the way you are hoping it does. According to https://www.postgresql.org/docs/current/auth-username-maps.html what the map does is

Re: Q: cert authentication and user remapping fails

2019-12-06 Thread Tom Lane
Albrecht =?iso-8859-1?b?RHJl3w==?= writes: > In my installation, the user certificate CN's contain human-readable names > (utf8, with spaces, etc.). I want *all* users connecting with cert > authentication to be mapped to a certain database role. I don't think that the user name mapping featur

Q: cert authentication and user remapping fails

2019-12-06 Thread Albrecht Dreß
Hi all, I have a problem with psql cert authentication and user mapping. In my installation, the user certificate CN's contain human-readable names (utf8, with spaces, etc.). I want *all* users connecting with cert authentication to be mapped to a certain database role. The server runs on D