<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><span>Nvm, figured it out. Had to add:</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="background-color: transparent;">custom_variable_classes = 'pgpool' # list of custom variable class names</div><div style="background-color: transparent;"><span></span></div><div style="background-color: transparent;">pgpool.pg_ctl = '/usr/pgsql-9.1/bin/pg_ctl'</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">Thanks for your
help</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Bryan Payne <bdptcob@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, April 7, 2014 9:27 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Pgpool unrecognized configuration paramet<br> </font> </div> <div class="y_msg_container"><br><div id="yiv0838386518"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif;
font-size: 12pt;"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><span>I've added that to each pool member:</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br clear="none"></span></div><div style="background-color:transparent;"><span>pgpool.pg_ctl = '/usr/pgsql-9.1/bin/pg_ctl'<br clear="none"></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br clear="none"></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>Reloading gives this message:</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size:
16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br clear="none"></span></div><div style="background-color:transparent;"><span>LOG: unrecognized configuration parameter "pgpool.pg_ctl"<br clear="none"></span></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><span><br clear="none"></span></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><span>If I connect to template1, I see the following functions:</span></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><span><br clear="none"></span></div><div style="background-color:transparent;">postgres=# \c
template1</div><div style="background-color:transparent;">You are now connected to database "template1" as user "postgres".</div><div style="background-color:transparent;">template1=# \df</div><div style="background-color:transparent;"> List of functions</div><div style="background-color:transparent;"> Schema | Name | Result data type | Argument data types | Type </div><div style="background-color:transparent;">--------+---------------------+------------------+---------------------+--------</div><div style="background-color:transparent;"> public | pgpool_pgctl | boolean | text, text | normal</div><div style="background-color:transparent;"> public | pgpool_recovery
| boolean | text, text, text | normal</div><div style="background-color:transparent;"> public | pgpool_remote_start | boolean | text, text | normal</div><div style="background-color:transparent;"> public | pgpool_switch_xlog | text | text | normal</div><div style="background-color:transparent;"><span></span></div><div style="background-color:transparent;">(4 rows)</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br clear="none"></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br clear="none"></div> <div style="font-family: 'times new roman',
'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"><pre>Hi,
I'm afraid that you might not add the parameter "pgpool.pg_ctl" into
postgresql.conf or not reload the database clusters.
Configuring pgpool.pg_ctl
<a rel="nofollow" shape="rect" target="_blank" href="http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions">http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions</a>
----
$ cat >> /usr/local/pgsql/postgresql.conf
pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl'
$ pg_ctl reload -D /usr/local/pgsql/data
----
><i> When doing anything via pgpoolAdmin in regards to a node (stop, restarting, starting, reloading), I get the following error in that node's postgres log:
</i>><i>
</i>><i> ERROR: unrecognized configuration parameter "pgpool.pg_ctl"
</i>><i> STATEMENT: SELECT pgpool_pgctl('reload', '')
</i>><i>
</i>><i> I've loaded the function sqls on the nodes:
</i>><i>
</i>><i> psql -f pgpool-recovery.sql -U postgres template1
</i>><i>
</i>><i> psql -f pgpool-regclass.sql -U postgres template1
</i>><i>
</i>><i>
</i>><i> I'm sure I've missed a step. Any ideas?
</i>
--
Nozomi Anzai
SRA OSS, Inc. Japan
</pre><div class="yiv0838386518yqt8860317173" id="yiv0838386518yqtfd80855"><div><br clear="none"></div> </div></div><div class="yiv0838386518yqt8860317173" id="yiv0838386518yqtfd74868"><div class="yiv0838386518y_msg_container"><br clear="none"><br clear="none"></div> </div></div><div class="yiv0838386518yqt8860317173" id="yiv0838386518yqtfd73605"> </div></div><div class="yiv0838386518yqt8860317173" id="yiv0838386518yqtfd10673"> </div></div></div></div><br><br></div> </div> </div> </div></body></html>