From: | "bzb(dot)dev001(at)gmail(dot)com" <bzb(dot)dev001(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13188: .pgpass does not work |
Date: | 2015-04-29 21:39:30 |
Message-ID: | 55414F92.5030901@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2015-04-29 04:41 PM, Jeff Janes wrote:
> On Wed, Apr 29, 2015 at 11:23 AM, bzb(dot)dev001(at)gmail(dot)com
> <mailto:bzb(dot)dev001(at)gmail(dot)com> <bzb(dot)dev001(at)gmail(dot)com
> <mailto:bzb(dot)dev001(at)gmail(dot)com>> wrote:
>
>>
> I've changed back the owner of .pgpass to the account that I've
> logged in as. This is the account that I'm using to run psql.
> All the spaces in .pgpass is removed.
> Checked that the permission settings of .pgpass is ok.
> restarted the server...
>
> $ sudo service postgresql restart
>
> Unfortunately, it is still not working.
>
> $ psql --host=localhost --port=5432 --username=postgres --no-password
> psql: fe_sendauth: no password supplied
>
>
> I wonder if it is even finding the file in the first place.
>
> strace psql --host=localhost --port=5432 --username=postgres
> --no-password 2>&1 | fgrep pgpass
>
> This is what I get:
>
> stat("/home/jjanes/.pgpass", {st_mode=S_IFREG|0600, st_size=196, ...}) = 0
> open("/home/jjanes/.pgpass", O_RDONLY) = 3
>
> For me it found the file and opened it successfully.
>
> Cheers,
>
> Jeff
I finally figured out why it didn't work. the port# specified in my
.pgpass was incorrect.
My stupidity.
Thanks to all for the help.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2015-04-29 21:50:15 | Re: Failure to coerce unknown type to specific type |
Previous Message | bzb.dev001@gmail.com | 2015-04-29 20:42:57 | Re: BUG #13188: .pgpass does not work |