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

Поиск
Список
Период
Сортировка
От Nick B
Тема Re: User Name Maps seem broken in 11.1 on CentOS 7
Дата
Msg-id CAPHA_mnH60roKg-4rYOOkOcPCDF1L7NZqBLDTR+nSsxzKtB5Fg@mail.gmail.com
обсуждение исходный текст
Ответ на User Name Maps seem broken in 11.1 on CentOS 7  (Viktor Berke <bviktor@outlook.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: User Name Maps seem broken in 11.1 on CentOS 7
Следующее
От: Sathish Kumar
Дата:
Сообщение: Re: Anonymize Data