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

From: Nick B <nbedxp(at)gmail(dot)com>
To: bviktor(at)outlook(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User Name Maps seem broken in 11.1 on CentOS 7
Date: 2019-01-29 22:07:30
Message-ID: CAPHA_mnH60roKg-4rYOOkOcPCDF1L7NZqBLDTR+nSsxzKtB5Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Sathish Kumar 2019-01-29 23:28:11 Re: Anonymize Data
Previous Message Tom Lane 2019-01-29 22:06:32 Re: User Name Maps seem broken in 11.1 on CentOS 7