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

Nozomi Anzai anzai at sraoss.co.jp
Mon Apr 14 11:02:56 JST 2014


Hi,

Yes, PostgreSQL 9.1 needs custom_variable_classes to use custom
varriables of modules.
But PostgreSQL 9.2 and 9.3 don't need to add it, and I tested
pgpool_pgctl () in 9.2 and 9.3. I will add this notification to the
document about pgpool.pg_ctl.

Thank you for your report.


> 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 �� yahoo.com>
> To: "pgpool-general �� pgpool.net" <pgpool-general �� 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 


-- 
Nozomi Anzai
SRA OSS, Inc. Japan


More information about the pgpool-general mailing list