Nicolas Michel <nicolas.michel@xxxxxxxxx> writes: > I tried to put my password in a .pgpass file into the home directory of > the root user (so /root/.pgpass). Here is a cat of that file : > *:*:*:*:test > (I tried only with stars to be sure my rule was not too strict). > So, il I try this command : > root@pc:~ # psql -h localhost -U postgres > I get : > psql: FATAL: authentification par mot de passe échouée pour > l'utilisateur « postgres » If it is not prompting you for a password then it must have successfully gotten a password out of the file (and then failed because it's the wrong password). I'm guessing the problem is something silly like extra trailing space on the line with the password. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
