[pgpool-hackers: 593] Re: Proposal: change format of pgpool_status

[Tatsuo Ishii]

>  Hi,
> Text format status file is a good thing - easier to read, debug and
> share.

I have just committed and pushed the changes for this. Will appear in
3.4.0.

> I find the mix of status information and configuration in one file
> quite confusing. Can't be the same scenario solved by setting the
> initial state of standby nodes in the existing configuration file?

But separating them brings a benefit. You could discard pgpool_status
anytime you get into trouble. pgpool.conf is more like a configuration
file, thus it may be a suprising for users if pgpool frequently
modifies it. Also it brokes applications which reads/write
pgpool.conf, like pgpoolAdmin.

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

> Kind Regards,
> Lukas Rypl
> 
> On 07/16/2014 06:58 AM, Tatsuo Ishii wrote:
>> Hi pgpool hackers,
>>
>> Currently pgpool-II uses binary 512-byte-long format pgpool_status.
>> If we could have the file in a text format, there's some values for
>> users:
>>
>> 1) easy to check contents of pgpool_status.
>>
>> 2) create/modify pgpool_status by ordinary text editor.
>>
>> Especially #2 is important. If we have a fresh pgpool-II cluster and
>> there are many standby servers, typical operation would be as follows:
>>
>> 1) start pgpool-II
>> 2) wait for health check process detects standbys are dead
>> 3) start online recovery for each standby node one by one
>>
>> #2 could take long time like tens of minutes if we set health check
>> retries. The only workaround is temporary disabling retry and
>> enabling later on. This is ugly. If we could create pgpool_status with
>> down standby status beforehand, #2 will be instant.
>>
>> Comments and/or suggestions are welcome.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> _______________________________________________
>> pgpool-hackers mailing list
>> pgpool-hackers at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>>
> 
> -- 
> Lukas Rypl
> Senior SW Developer
> 
> TTC MARCONI s. r. o.
> Třebohostická 987/5
> 100 00  Praha 10
> 
> www.ttc-marconi.com
> 
> Tel.: +420 234 051 842
> E-mail: rypl at marconi.ttc.cz
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers