Re: Using both ident and password in pg_hba.conf

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using both ident and password in pg_hba.conf
Date: 2016-05-09 21:06:37
Message-ID: 20160509210637.GA12525@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 09, 2016 at 13:39:48 -0700,
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>The above does not make sense to me. Maybe I am not understanding if
>you mean connect and login as the same thing or not? I could see
>connecting as 'nobody' and then doing SET ROLE as user. Or connect as
>'nobody' for the PHP script and have a separate connection as the
>database user. Otherwise you are going to have to explain more about
>what you are doing.

The mapping is between system and postgres users. So that the system user
nobody is allowed to login as any of the postgres users a, b or c.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-05-09 21:12:22 Re: Using both ident and password in pg_hba.conf
Previous Message Adrian Klaver 2016-05-09 20:39:48 Re: Using both ident and password in pg_hba.conf