Re: pgadmin4 won't use pgpass file

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.don@gmail.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)