Postgres Account Inherit Question - Mailing list pgsql-general

From Carlos Mennens
Subject Postgres Account Inherit Question
Date
Msg-id CAAQLLO7dAANHvxepx49Z7r6wunYvdWMwDTm_gCNfBxV+U5q0nA@mail.gmail.com
Whole thread Raw
Responses Re: Postgres Account Inherit Question  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
I've configured my 'pg_hba.conf' file to look as follows:

# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.168.0.0/24        md5

Now I've reloaded / restarted the PostgreSQL daemon however for some
reason when I use the 'postgres' user locally, it never prompts for a
password in 'psql'. I've altered the role to NOINHERIT

postgres=# ALTER ROLE postgres NOINHERIT;
ALTER ROLE

Any other role locally requires a password to even list the database
using 'psql -l' command except the 'postgres' role. Is this normal
behavior or am I missing something here? How can I force the postgres
account to be prompted for a password when communicating to the
database server locally?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: information_schema.referential_constraints contains NULLs
Next
From: Julien Rouhaud
Date:
Subject: Re: Postgres Account Inherit Question