Re: dblink authentication issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daulat <daulat(dot)dba(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: dblink authentication issue
Date: 2023-04-21 14:21:27
Message-ID: 3338293.1682086887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Daulat <daulat(dot)dba(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daulat 2023-04-22 06:53:31 Re: dblink authentication issue
Previous Message Daulat 2023-04-21 12:24:11 dblink authentication issue