From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Stephen Rasku <postgres(at)srasku(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: .pgpass being ignored |
Date: | 2013-06-21 22:33:30 |
Message-ID: | 51C4D4BA.5040208@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 21/06/2013 23:25, Stephen Rasku wrote:
> 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?
What's in your server's pg_hba.conf file?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-06-21 22:41:28 | Re: .pgpass being ignored |
Previous Message | Stephen Rasku | 2013-06-21 22:25:46 | .pgpass being ignored |