[pgpool-general: 2695] Re: Fwd: Re: Re: pcp_recovery_node failing in stage 1
Tatsuo Ishii
ishii at postgresql.org
Thu Apr 3 07:27:08 JST 2014
> I have just found the problem. I had set the PostgreSQL statement_timeout to 60000 (10 minutes), so it was actually PostgreSQL itself that was killing the SELECT pgpool_recovery('do-base-backup.sh', 'psql02.compusult.net', '/var/lib/pgsql/9.2/data') statement.
>
> I think it would be a good idea to mention in the pgpool documentation that statement_timeout, if set, must be longer than the time it takes to do the 1st stage recovery command.
>
> Thanks for your help,
> Sean
Thank you for precious information! I will add this to the doc.
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