[pgpool-general: 5340] Re: unrecognized configuration parameter "pool_status"

Tatsuo Ishii ishii at sraoss.co.jp
Fri Feb 17 15:05:56 JST 2017


Can you show me pgpool_setup.log and log/pgpool.log?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: "Yugandha Deshpande" <yugandha at us.ibm.com>
Subject: Re: [pgpool-general: 5335] Re: unrecognized configuration parameter "pool_status"
Date: Fri, 17 Feb 2017 11:30:26 +0530
Message-ID: <OFCD15E5EE.8631FAAA-ON002580CA.0020C0C2-652580CA.0020FFB9 at notes.na.collabserv.com>

> 
> Hi,
> 
> 	I am building pgpool2 from git source, master branch.
> 
> 	$pgpool2 --version
> 	pgpool-II version 3.7devel (amefuriboshi)
> 
> 	I ran pgpool_setup without -p flag, and have attached the log here.
> 
> 	(See attached file: pgpool_log_without_p.txt)
> 
> Thanks & Regards,
> Yugandha.
> 
> 
> 
> From:	Tatsuo Ishii <ishii at sraoss.co.jp>
> To:	Yugandha Deshpande/Austin/Contr/IBM at IBMUS
> Cc:	lazaro3487 at gmail.com, pgpool-general at pgpool.net
> Date:	02/17/2017 11:17 AM
> Subject:	Re: [pgpool-general: 5335] Re: unrecognized configuration
>             parameter "pool_status"
> 
> 
> 
> Which version of Pgpool-II is it?
> 
> Also can you try without -p option?
> 
>> bash -x /usr/local/bin/pgpool_setup -p 5432 > pgpool_setup_output
> 
>> Hi,
>>
>> 		 Yes Tatsuo, I want to run regression tests. I am using
> RHEL-7.3.
>> 		 As you suggested I ran "bash -x /path/to/pgpool_setup", I have
>> attached the log here.
>>
>> (See attached file: pgpool_setup_debug_log.txt)
>>
>>
>> Thanks & Regards,
>> Yugandha.
>>
>>
>>
>> From:		 Tatsuo Ishii <ishii at sraoss.co.jp>
>> To:		 lazaro3487 at gmail.com
>> Cc:		 Yugandha Deshpande/Austin/Contr/IBM at IBMUS,
>>             pgpool-general at pgpool.net
>> Date:		 02/17/2017 07:16 AM
>> Subject:		 Re: [pgpool-general: 5335] Re: unrecognized
> configuration
>>             parameter "pool_status"
>>
>>
>>
>> Lazaro,
>>
>> I think Yugandha wanted to run the regression test (the test runs
>> pgpool_setup inside), not want to use pgpool_set for production
>> purpose.
>>
>> Yugandha,
>>
>> Can you run pgpool_setup by "bash -x /path/to/pgpool_setup" to take
>> debugging output? Also I would like to know what OS/distribution you
>> are using.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> From: "Lazaro Garcia" <lazaro3487 at gmail.com>
>> Subject: [pgpool-general: 5335] Re: unrecognized configuration parameter
>> "pool_status"
>> Date: Thu, 16 Feb 2017 11:12:23 +0100
>> Message-ID: <001101d2883d$2c795f20$856c1d60$@gmail.com>
>>
>>> pool_status is an invalid configuration parameter for pgpool. I never
>> used
>>> pgpool_setup, but the documentation says that this command is not
>> recomended
>>> for production enviroment. For this reason I always create all by hand.
>>>
>>>
>>>
>>> I recomend you create your postgres cluster, then install and configure
>>> pgpool using the samples configuration files proposed by pgpool
>> developers.
>>>
>>>
>>>
>>>
>>>
>>> Regards.
>>>
>>>
>>>
>>> De: pgpool-general-bounces at pgpool.net
>>> [mailto:pgpool-general-bounces at pgpool.net] En nombre de Yugandha
>> Deshpande
>>> Enviado el: jueves, 16 de febrero de 2017 10:53 a. m.
>>> Para: pgpool-general at pgpool.net
>>> Asunto: [pgpool-general: 5334] unrecognized configuration parameter
>>> "pool_status"
>>>
>>>
>>>
>>> Hi,
>>> I am trying to build pgpool2.
>>> OS: Linux
>>>
>>>
>>> I could build it successfully. But when I run tests, it fails. Also if I
>> run
>>> pgpool_setup command it fails with following log:
>>>
>>> LOG:
>>> ERROR: unrecognized configuration parameter "pool_status"
>>>
>>> ERROR: unrecognized configuration parameter "pool_status"
>>> ERROR: unrecognized configuration parameter "pool_status"
>>> ERROR: unrecognized configuration parameter "pool_nodes"
>>> recovery node 1...ERROR: connection to host "localhost" failed with
> error
>>> "Connection refused"
>>> done.
>>> creating follow master script
>>> ERROR: unrecognized configuration parameter "pool_nodes"
>>> shutdown all
>>>
>>> pgpool-II setting for streaming replication mode is done.
>>> To start the whole system, use /root/yugandha/pgpool2/o/o/startall.
>>> To shutdown the whole system,
> use /root/yugandha/pgpool2/o/o/shutdownall.
>>> pcp command user name is "test", password is "test".
>>> Each PostgreSQL, pgpool-II and pcp port is as follows:
>>> #1 port is 11002
>>> #2 port is 11003
>>> pgpool port is 5432
>>> pcp port is 5433
>>> The info above is in README.port.
>>>
>>> Has anyone seen similar issue, if so please suggest if I have missed any
>>> step or configuration.
>>>
>>>
>>> Thanks & Regards,
>>> Yugandha.
>>>
>>
>>
>>
> 
> 
> 


More information about the pgpool-general mailing list