Re: BUG #13188: .pgpass does not work

On Wed, Apr 29, 2015 at 8:09 AM, bzb(dot)dev001(at)gmail(dot)com <bzb(dot)dev001(at)gmail(dot)com>
wrote:
I have even changed the ownership of the file to postgres:postgres since
I'm logged on as another user and .pgpass is located in this user's home
directory. Yet it still does not work.
>
>
> $ ls -l .pgpass
> -rw------- 1 postgres postgres 79 Apr 29 10:24 .pgpass
>

​Sorry, I missed this the first time reading. This is your problem. The
"postgres" Linux user and the "postgres" PostgreSQL user are not related to
each other - particularly when using md5 authentication. The permissions
on the .pgpass file must be of the user executing "psql" - which you've
indicated is not "postgres".

So, likely your first attempt failed because you had whitespace. You
changed the permissions and now have two problems. You then fix the
whitespace and are back to a single problem. Change the permissions back
and it should now work.

David J.

​