Re: Postgresql gss user map doesn't work

On Tue, Jun 30, 2015 at 11:37 PM, xujian <jamesxu(at)outlook(dot)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/