<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>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></span></div><div style="background-color: transparent;"><span>pgpool.pg_ctl = '/usr/pgsql-9.1/bin/pg_ctl'<br></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="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></span></div><div style="background-color: transparent;"><span>LOG: unrecognized configuration parameter "pgpool.pg_ctl"<br></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></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></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></span></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"><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 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><br></div> </div><div class="y_msg_container"><br><br></div> </div> </div> </div></body></html>