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

[Rypl Lukas]

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

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?

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