pgadmin4 won't use pgpass file

From: Saulteau Don <sault(dot)don(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: pgadmin4 won't use pgpass file
Date: 2019-02-15 16:56:08
Message-ID: CAJo0jfPpSYddS5O7bfF5UFZO4x-HTybRujuxaC8DZRMhX3euJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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)

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Silvera, Ignacio 2019-02-16 12:46:04 Re: pgadmin4 won't use pgpass file
Previous Message Khushboo Vashi 2019-02-15 13:31:05 Re: pgadmin modify role properties