From: | Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Problem with .pgpass |
Date: | 2009-05-18 15:23:10 |
Message-ID: | 1242660190.20437.205.camel@nm-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 :
root(at)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 :
root(at)pc:~ # psql -h localhost -U postgres
When prompt for a password, I enter 'test' and it's working ...
Someone understand where's the problem?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-05-18 15:59:55 | Re: Problem with .pgpass |
Previous Message | 2009-05-17 15:00:28 | Re: installation of Postgre |