Re: Problem with .pgpass

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(dot)michel(at)lemail(dot)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 :
>
> > root(at)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
>