[pgpool-general: 2716] Re: Pgpool unrecognized configuration paramet

Bryan Payne bdptcob at yahoo.com
Tue Apr 8 00:27:48 JST 2014

I've added that to each pool member:

pgpool.pg_ctl = '/usr/pgsql-9.1/bin/pg_ctl'

Reloading gives this message:

LOG:  unrecognized configuration parameter "pgpool.pg_ctl"

If I connect to template1, I see the following functions:

postgres=# \c template1
You are now connected to database "template1" as user "postgres".
template1=# \df
                               List of functions
 Schema |        Name         | Result data type | Argument data types |  Type  
 public | pgpool_pgctl        | boolean          | text, text          | normal
 public | pgpool_recovery     | boolean          | text, text, text    | normal
 public | pgpool_remote_start | boolean          | text, text          | normal
 public | pgpool_switch_xlog  | text             | text                | normal
(4 rows)


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 http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions ----
$ cat >> /usr/local/pgsql/postgresql.conf
pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl' $ pg_ctl reload -D /usr/local/pgsql/data
---- >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:  >>ERROR:  unrecognized configuration parameter "pgpool.pg_ctl" >STATEMENT:  SELECT pgpool_pgctl('reload', '') >>I've loaded the function sqls on the nodes: >>psql -f pgpool-recovery.sql -U postgres template1 >>psql -f pgpool-regclass.sql -U postgres template1 >>>I'm sure I've missed a step. Any ideas?  -- 
Nozomi Anzai
SRA OSS, Inc. Japan 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140407/d1fc57fe/attachment-0001.html>

More information about the pgpool-general mailing list