| 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: | Whole Thread | Raw Message | 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 |