Re: dblink authentication issue

Daulat <daulat.dba@gmail.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