Re: dblink authentication issue

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>