Re: Using both ident and password in pg_hba.conf - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Using both ident and password in pg_hba.conf
Date
Msg-id 20160509210637.GA12525@wolff.to
Whole thread Raw
In response to Re: Using both ident and password in pg_hba.conf  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Mon, May 09, 2016 at 13:39:48 -0700,
  Adrian Klaver <adrian.klaver@aklaver.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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using both ident and password in pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: Create index concurrently hanging with big table on pgsql 9.3.12