[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