On Fri, 2011-10-14 at 18:44 +0200, Julien Rouhaud wrote: > On Fri, Oct 14, 2011 at 6:38 PM, Carlos Mennens <carlos.mennens@xxxxxxxxx>wrote: > > > 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? > > > > > Hi > Did you check for a .pgpass file ? And do you have any other lines before the few ones you give ? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
