Re: pgadmin4 won't use pgpass file

Hi Ignacio and Martuza, thanks for the pointers.

The file permissions were good and it turns out it was the host addr of
localhost causing a problem.

I did have to change it to /var/run/postgresql

I originally used localhost because of the postgresql (was looking at OLD
docs from 9.4! my mistake) docs and thought it would resolve to the default
socket directory:

A host name of localhost matches both TCP (host name localhost) and Unix
domain socket (pghost empty or the default socket directory) connections
coming from the local machine.

On Sun, Feb 17, 2019 at 8:43 AM Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

> The documents say
> `*The host name field is matched to the host connection parameter if that
> is specified, otherwise to the hostaddr parameter if that is specified; if
> neither are given then the host name localhost is searched for. The host
> name localhost is also searched for when the connection is a Unix-domain
> socket connection and the host parameter matches libpq's default socket
> directory path*`
>
> Ref: https://www.postgresql.org/docs/devel/libpq-pgpass.html
>
> So you need to provide the same value of the host field from
> server properties dialog into pgpass file.
>
> Can you try with following?
> /var/run/postgresql:5432:newdb:postgres:**********
>
>
> -- Murtuza
>
>
> On Sat, Feb 16, 2019 at 2:06 PM Saulteau Don <sault(dot)don(at)gmail(dot)com> wrote:
>
>> I'm running postgresql 11.1 (via unix socket only) and pgadmin 4.2 on
>> linux.
>>
>> I have a .pgpass file for the postgres user to a specific database but
>> pgadmin4 keeps asking for a password. Using psql from the command line
>> works fine.
>>
>> my pgpass looks like the following
>> localhost:5432:newdb:postgres:**********
>>
>> Setting up a connection to the server in pgadmin4 I tried the following:
>> General (tab):
>> Name = newdb admin
>>
>> Connection (tab):
>> Host name/address = /var/run/postgresql
>> Port = 5432
>> Maintenance database = newdb
>> Username = postgres
>>
>> Advanced (tab)
>> Password file = /home/saultdon/.pgpass
>>
>> When I hit Save it says,
>> Unable to connect to server:
>> fe_sendauth: no password supplied
>>
>> Where I thought it would use the pgpass file but it doesn't.
>> So I enter a password in the Connection(tab) just to make the first
>> connection.
>>
>> I relaunch pgadmin4 and try to connect to the db but it asks for a
>> password with the error message:
>> fe_sendauth: no password supplied
>> Please enter the password for the user 'postgres' to connect to the
>> server - "newdb"
>>
>> I'm not sure what else I need to do to get pgadmin4 to use this .pgpass
>> file.
>>
>>
>>
>> Donovan (saultdon)
>>
>