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

[Bryan Payne]

Nvm, figured it out. Had to add:

custom_variable_classes = 'pgpool'   # list of custom variable class names
pgpool.pg_ctl = '/usr/pgsql-9.1/bin/pg_ctl'

Thanks for your help


________________________________
 From: Bryan Payne <bdptcob at yahoo.com>
To: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Sent: Monday, April 7, 2014 9:27 AM
Subject: Re: Pgpool unrecognized configuration paramet
 


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/d00f6c1f/attachment.html>