[pgpool-general: 4795] Re: PGPool Command Line tools in bash

Tatsuo Ishii ishii at postgresql.org
Tue Jul 19 21:29:14 JST 2016


> Ah - that's nicer. Not sure why i couldn't find this in my googling.
> 
> Much appreciated Tatsuo.
> 
> steven

Actually it's in the official doc, which should come with the source code.
If not, you can take a look at this:

http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_command

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

> On Tue, Jul 19, 2016 at 1:19 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>> Hi folks.
>>>
>>> Since I had last updated PGPool and the current version, it seems that
>>> how you pass parameters to the command line tools such as
>>> pcp_node_count and pcp_detach_node etc has changed such that you can't
>>> add the password as a parameter any more.
>>>
>>> I was using this in my bash scripts previously to automate things
>>> which now no longer works.
>>>
>>> Is there an alternative method people are using rather than resorting
>>> to "expect" hacks etc?
>>
>> You can use ".pcppass" file to store password info.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list