Re: psql -c "select * from a-user-name-that-exist fails

Hi Josh,
Thanks for your help. I have recreated the user laurent with :
$ createuser -S -d -l -P -E -U postgres laurent
from the postgres linux user.

From the documentation, I should be able to login since LOGIN is default for
createuser and for the case, I force it with -l. But I just cannot login :
$ createdb -U laurent mydb -W
Mot de passe :
createdb : n'a pas pu se connecter à la base de données postgres : n'a pas
pu se connecter au serveur : Permission non accordée
Le serveur est-il actif localement et accepte-t-il les connexions sur la
socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?

Which translate to :
createdb: could not connect to database postgres: could not connect to
server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

I am in the pg_user view :
postgres=# SELECT usename FROM pg_user;
usename
----------
postgres
laurent
(2 lignes)

and the pg_role one :
postgres=# SELECT rolname FROM pg_roles;
rolname
----------
postgres
laurent
(2 lignes)

My pg_hba.conf is not a showstopper :
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust

Now for your checks :
postgres=# SELECT rolcanlogin FROM pg_authid WHERE rolname = 'laurent';
rolcanlogin
-------------
t
(1 ligne)
So it looks ok, isn't it ?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-c-select-from-a-user-name-that-exist-fails-tp2852042p2852359.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.