[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: User Name Maps seem broken in 11.1 on CentOS 7
From:       Nick B <nbedxp () gmail ! com>
Date:       2019-01-29 22:07:30
Message-ID: CAPHA_mnH60roKg-4rYOOkOcPCDF1L7NZqBLDTR+nSsxzKtB5Fg () mail ! gmail ! com
[Download RAW message or body]

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` in terminal without specifying an actual user name.
The way to do this properly would be to execute `psql -U postgres`.

Unfortunately, you've left before I was able to tell you this.

Kind regards,
Nick.

[Attachment #3 (text/html)]

<div dir="ltr">Hey!<div><br></div><div>I think I&#39;ve figured out what was your \
problem.</div><div><br></div><div>You have created a mapping to allow OS user \
&quot;foobar&quot; auth as pg role \
&quot;postgres&quot;.</div><div><br></div><div>What happens though (and error message \
actually indicates that) is you are trying to authenticate as pg role \
&quot;foobar&quot;. This is probably due to you executing `psql` in terminal without \
specifying an actual user name.</div><div>The way to do this properly would be to \
execute `psql -U postgres`.</div><div><br></div><div>Unfortunately, you&#39;ve left \
before I was able to tell you this.</div><div><br></div><div>Kind \
regards,</div><div>Nick.</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]