[pgpool-general: 2959] Re: configurable timeout for 1st stage recovery

Sean Hogan sean at compusult.net
Tue Jun 24 19:52:58 JST 2014


Thanks.  :-)

On 14-06-21 08:05 AM, Tatsuo Ishii wrote:
> Hi Sean,
>
>>> So this is a dilemma.  statement_timeout can be set on a
>>> per-connection basis, but I believe it is not possible to do it for
>>> the connection that pgpool uses to run the 1st stage recovery command.
>>> If I am wrong about that then please let me know, but otherwise I
>>> think it would be extremely useful to have a configuration property to
>>> set the statement_timeout on that particular connection.
> I have committed a fix following your direction, i.e. disable
> statement timeout in the connection to run the online recovery. Thanks
> for the hint!
>
> The commit for 3.3-stable is here:
> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b9bb86d3bb69873f2e1b441820a02b632f00e3e6
>
> You can get patch agaist pgpool-II 3.3.3 by following "patch" link.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140624/7c85045d/attachment.vcf>


More information about the pgpool-general mailing list