pgAdmin and Postgres_fdw needing superuser access - Mailing list pgadmin-support
From | Adam Pearson |
---|---|
Subject | pgAdmin and Postgres_fdw needing superuser access |
Date | |
Msg-id | A09FF13F31F4184D8DDD607B8197B98C3C369025@dcm1-exm-002.ofg.local Whole thread Raw |
List | pgadmin-support |
<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>
pgadmin-support by date: