<div dir="ltr">pgpool_adm module implements two kinds of functions. One those takes, username, password, server address and port as a parameter and second type gets these credentials from foreign server and takes the foreign server name as an argument.<div><br></div><div>Signature of pcp_node_info that takes everything as an argument.<br><font face="monospace, monospace">pcp_node_info(integer node_id, text host, integer port, text username, text password, OUT status text, OUT weight float4) returns record<br></font><br>Signature of pcp_node_info that takes foreign server name. <br><font face="monospace, monospace">pcp_node_info(integer node_id, text pcp_server, OUT status text, OUT weight float4) returns record</font></div><div><br><div>See for more details</div><div><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#pgpool_adm" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#pgpool_adm<br></a></div><div><br></div><div><div><br></div><div>Now you are trying to call <span style="color:rgb(0,0,0)"><i>pcp_node_info</i> that takes the foreign server name as an argument. (</span><font face="monospace, monospace"><span style="color:rgb(0,0,0)">SELECT * FROM </span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)">pgpool</span><span style="color:rgb(0,0,0)">.</span><span style="color:rgb(0,0,0)">pcp_node_info</span><span style="color:rgb(0,0,0)">(</span><span style="color:rgb(0,0,0)">0,</span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"></span><span style="color:rgb(0,0,0)"> '</span><span style="color:rgb(0,0,0)">localhost</span></font><span style="color:rgb(0,0,0)"><font face="monospace, monospace">');</font>)</span></div><div>So Have you added the foreign server named 'localhost'? </div><div><br></div><div>I can successfully execute the pcp_node_info using raw credentials and foreign server.<br></div><div><br></div><div>See the below example</div><div><br></div><div><div><font face="monospace, monospace">postgres=# create foreign data wrapper dummy;</font></div><div><font face="monospace, monospace">CREATE FOREIGN DATA WRAPPER</font></div></div><div><div><font face="monospace, monospace">postgres=# create server pcp_server foreign data wrapper dummy options(host 'localhost', port '9891', user 'postgres', password 'postgres');</font></div><div><font face="monospace, monospace">CREATE SERVER</font></div></div><div><font face="monospace, monospace">postgres=# create user mapping for postgres server pcp_server options (user 'postgres', password 'postgres');<br></font></div><div><font face="monospace, monospace"><div>CREATE USER MAPPING</div></font></div><div><div><font face="monospace, monospace">postgres=# SELECT * FROM pgpool.pcp_node_info(0, 'pcp_server');</font></div><div><font face="monospace, monospace"> host | port | status | weight </font></div><div><font face="monospace, monospace">-----------+------+-------------------+--------</font></div><div><font face="monospace, monospace"> 127.0.0.1 | 5432 | Connection in use | 0</font></div><div><font face="monospace, monospace">(1 row)</font></div></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace"><br></font></div><div>Regards</div><div>Muhammad Usama </div><div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Mar 13, 2016 at 2:55 PM, Avi Weinberg <span dir="ltr"><<a href="mailto:AviW@gilat.com" target="_blank">AviW@gilat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black">Hi All,<u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black">I'm using pgpool 3.5 and I have two postgres machines and two pgpool machines – total 4 servers.
<u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black">I would like to know if pgpool_adm is installed on the postgres machines or the pgpool machine. I assume that if it is installed on the pgpool machine I
will have to install postgres on those machines as well right?<u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black">Currently I get an error "server localhost does not exist" when installing it on the postgres machine.<u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr"><span style="color:black"> CREATE SCHEMA pgpool;<br>
CREATE EXTENSION pgpool_adm WITH SCHEMA pgpool ;<br>
SELECT * FROM pgpool.pcp_node_info(0, 'localhost');<br>
<br>
</span><u></u><u></u></p>
<p class="MsoNormal" style="text-align:left;direction:ltr">Thanks<u></u><u></u></p>
</div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div></div></div></div>