Re: dblink authentication issue - Mailing list pgsql-admin

From Daulat
Subject Re: dblink authentication issue
Date
Msg-id CALfOM6JBGYxZtW=E-a9emi_e=nHfa8_nogyRKrMrVWc8yBO1bg@mail.gmail.com
Whole thread Raw
In response to Re: dblink authentication issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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@sss.pgh.pa.us> wrote:
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: dblink authentication issue
Next
From: ROHIT SACHDEVA
Date:
Subject: Related To Hash Partition