Yes, I am using superuser "postgres".
It is the owner of the .pgpass file.
Thanks,
On Fri, Apr 21, 2023 at 7:51 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Daulat <daulat.dba@xxxxxxxxx> writes:
> I have some problem with using dblink_connect_u() while making a connection
> using a .pgpass file.
> select * from gis.dblink_connect_u('conn'||'X123','dbname='||'pgdb');
> ERROR: could not establish connection
> DETAIL: fe_sendauth: no password supplied
This is intentional: to use a .pgpass file belonging to the server owner,
you must be a database superuser.
regards, tom lane
