There was indeed a blank after the line (after the password)... ^^ To Scott : yes, I set the file with 0600 permissions ;)
Thank you very much for your help. Le lundi 18 mai 2009 à 11:59 -0400, Tom Lane a écrit : > Nicolas Michel <nicolas.mic...@lemail.be> 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 : > > > r...@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 >
