Hi here,

I'm trying to make my dump script working but it is not.

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 »

(this is in french but it means that the password authentication method
failed for the user 'postgres')

If I rename my .pgpass into .pgpass.old, I can log in to postgres with
the same command :

        r...@pc:~ # psql -h localhost -U postgres

When prompt for a password, I enter 'test' and it's working ...

Someone understand where's the problem?

Reply via email to