Re: Postgresql gss user map doesn't work

Поиск
Список
Период
Сортировка
От xujian
Тема Re: Postgresql gss user map doesn't work
Дата
Msg-id BAY181-W364FD9EA926BB32E0872A8A1A80@phx.gbl
обсуждение исходный текст
Ответ на Re: Postgresql gss user map doesn't work  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Postgresql gss user map doesn't work  (xujian <jamesxu@outlook.com>)
Tuning on server with both running oracle and postgreSQL database  (koff10 <koff10@hotmail.com>)
Список pgsql-admin
Дерево обсуждения
Thanks Magnus, you are awesome!

James


Date: Wed, 1 Jul 2015 08:38:45 +0200
Subject: Re: [ADMIN] Postgresql gss user map doesn't work
From: magnus@hagander.net
To: jamesxu@outlook.com
CC: pgsql-admin@postgresql.org



On Tue, Jun 30, 2015 at 11:37 PM, xujian <jamesxu@outlook.com> wrote:
it looks like I need to specify the mapping user name in the command, for instance, if my credential is xxx, I want to login as user company_com_xxx, I have to run command like

/psql -d dbname -h postgresql.server.name -U company_com_xxx

but why I need to specify the mapping user name company_com_xxx in command line? 
does anyone have same issue? thanks



Yes, that is working as intended. You always have to tell postgres which user you want to log in with, pg_ident only allows you to authenticate with a different name, you still have to tell the system which one you want.

You can also put the username in the PGUSER environment variable if it's something you want to deploy across many users.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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

Предыдущее
От: Shih Théo
Дата:
Сообщение: What is the correct steps if tar process is killed during pg_start_backup() and pg_stop_backup()
Следующее
От: xujian
Дата:
Сообщение: Re: Postgresql gss user map doesn't work