pgAdmin and Postgres_fdw needing superuser access

<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">HelloAll,</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">               Has anyone encountered a quirk with PGAdmin
andPostgres_fdw requiring superuser access?</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Forexample.</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Runthe below under my useraccount, sudo and it returns a
recordset.</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">selectid from foreign_address limit 10;</span><p
class="MsoNormal"><spanlang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Run the same code in
PGAdmin,my normal user account and it reports</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><i><span lang="EN-US"
style="font-size:8.0pt;font-family:"Calibri","sans-serif"">ERROR: password is required</span></i><p
class="MsoNormal"><i><spanlang="EN-US" style="font-size:8.0pt;font-family:"Calibri","sans-serif"">DETAIL: 
Non-superusercannot connect if the server does not request a password.</span></i><p class="MsoNormal"><i><span
lang="EN-US"style="font-size:8.0pt;font-family:"Calibri","sans-serif"">HINT:  Target server's authentication method
mustbe changed.</span></i><p class="MsoNormal"><i><span lang="EN-US"
style="font-size:8.0pt;font-family:"Calibri","sans-serif"">**********Error **********</span></i><p
class="MsoNormal"><i><spanlang="EN-US" style="font-size:8.0pt;font-family:"Calibri","sans-serif""> </span></i><p
class="MsoNormal"><i><spanlang="EN-US" style="font-size:8.0pt;font-family:"Calibri","sans-serif"">ERROR: password is
required</span></i><pclass="MsoNormal"><i><span lang="EN-US"
style="font-size:8.0pt;font-family:"Calibri","sans-serif"">SQLstate: 2F003</span></i><p class="MsoNormal"><i><span
lang="EN-US"style="font-size:8.0pt;font-family:"Calibri","sans-serif"">Detail: Non-superuser cannot connect if the
serverdoes not request a password.</span></i><p class="MsoNormal"><i><span lang="EN-US"
style="font-size:8.0pt;font-family:"Calibri","sans-serif"">Hint:Target server's authentication method must be
changed.</span></i><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">However,if I just run a normal select on a non-foreign
tableit works.</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Also,if I change my account to be a superuser it works. 
Confusesme slightly, since when setting up Postgres_fdw you specify the connection details in the user mapping. 
</span><pclass="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><p
class="MsoNormal"><spanlang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Is this a problem with
pgAdmin,or Postgres_fdw?  Seems to indicate an issue with pgAdmin?</span><p class="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><pclass="MsoNormal"><span lang="EN-US"
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Thanks& Regards,</span><p class="MsoNormal"><span
lang="EN-US"style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Adam Pearson</span></div>