DBLINK Error

Hello Team,

I am facing an issue while fetching data using dblink.
I am using a .pgpass file and MD5 for authentication.

.pgpass file is located in the home directory (postgres user home) of the
user running the PostgreSQL query. This file has proper permission 0600
and owner postgres to keep it secure. The OS is Amazon Linux.

Connection made successfully without giving password.

[root(at)DEM-MT bin]# ./psql -d postgres -U postgres
psql (14.6)
Type "help" for help.

postgres=#
cd /opt/PostgreSQL-14/bin/
[root(at)DEM-MT bin]# ./psql -d postgres -U postgres -W
Password:
psql (14.6)
Type "help" for help.

postgres=#

ERROR:
-----------

cd /opt/PostgreSQL-14/bin/
[postgres(at)DMM-MT bin]$ ./psql -U postgres -d tn2_demo_10

tn2_demo_10=# select * from
ucf.dblink_connect_u('conn','dbname="ADT_DEM_DB"');
ERROR: could not establish connection
DETAIL: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
fe_sendauth: no password supplied

Please help on this issue.

Thanks.