Descripción:

When running queries in the Postgres DDA database connection that have DBLINKs, the queries are throwing Password Authentication errors when trying to connect to other schemas.  This started after the upgrade to Postgres 16. 

Pasos para repetir:

1. Using PGADMIN 4 connect to the user  CMS_doc schema "BBdoc" and run a query to connect to the same user's Learn Schema
2. The query below has the password taken out

SELECT *

    FROM dblink('dbname=DDD user=ddauser1 password=########',

    'Select course_id, batch_uid from course_main')

    AS t1(course_id name, batch_uid text)

    WHERE course_id LIKE 'bbtest%';

Observed Behavior :

Connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  password authentication failed for user "ddauser1" could not establish a connection.

ERROR:  could not establish connection.

Expected Behavior:

Connection to server should be successful.