title: Non-superuser cannot connect if the server does not request a password while using dblink
body: <p>I want to do some cross database references in my application. Briefly, i have two databases called meta and op. I want to do some select query from meta to a table in op database like below but getting the below error. I tried with password and without password. by the way <code>caixa</code> user is a non-super user and my target server (<code>op</code> db server is having MD5 authentication mode.)</p>
  
  <pre><code>meta=&gt; select * from dblink('dbname=op password=caixa','SELECT op_col from op_table') AS t(op_col varchar);
  </code></pre>
  
  <blockquote>
    <p>ERROR:  password is required</p>
    
    <p>DETAIL:  Non-superuser cannot connect if the server does not request a password.</p>
    
    <p>HINT:  Target server's authentication method must be changed.</p>
  </blockquote>
  
  <p>What the HINT in the above error message suggests? do i need to change the server's auth mode? Without changing the server's auth mode (MD5) can't i run the above query?</p>