| From: | Stephen Rasku <postgres(at)srasku(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | .pgpass being ignored |
| Date: | 2013-06-21 22:25:46 |
| Message-ID: | CA+BUyJkTee_rPRz_aEG-UDATsrdEffd6f0OMbpX2M249N5wAnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw------- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass
However, when I call createdb, it fails:
$ createdb -h 192.168.1.4 -U postgres --no-password JobSearch
createdb: could not connect to database postgres: fe_sendauth: no
password supplied
This is the contents of my .pgpass file:
192.168.1.4:5432:DatabaseName:postgres:thisIsTheCorrectPassword
If I omit the --no-password option it will prompt me for a password
and the command will succeed. I am using 9.0.10 from MacPorts.
What am I doing wrong?
...Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2013-06-21 22:33:30 | Re: .pgpass being ignored |
| Previous Message | Stephen Rasku | 2013-06-21 22:19:16 | .pgpass being ignored |