Re: User Name Maps seem broken in 11.1 on CentOS 7

2019-01-29 Thread Nick B
Hey! I think I've figured out what was your problem. You have created a mapping to allow OS user "foobar" auth as pg role "postgres". What happens though (and error message actually indicates that) is you are trying to authenticate as pg role "foobar". This is probably due to you executing `psql

Re: User Name Maps seem broken in 11.1 on CentOS 7

2019-01-29 Thread Tom Lane
Adrian Klaver writes: > On 1/29/19 1:11 PM, Viktor Berke wrote: >> And here comes the problem: user name maps seem completely >> non-functional. > Is ident_file set to something else?: > https://www.postgresql.org/docs/11/runtime-config-file-locations.html#GUC-IDENT-FILE Also: have you been rel

Re: User Name Maps seem broken in 11.1 on CentOS 7

2019-01-29 Thread Adrian Klaver
On 1/29/19 1:11 PM, Viktor Berke wrote: Hi, After some talk with the helpful folks of #postgresql I see no other option but to ask here. I'm trying to set up proper authentication for our corprorate users. They'll access postgres both from their workstations via TCP, and also locally. Locally