[pgpool-general: 2667] Re: Restart Postgresql service

[Tatsuo Ishii]

> Hi!
> Almost every time I restart backend postgresql service ( while pgpool is working ) it causes pgpool to mark this node as failed.
> So I'm wondering if there is some 'proper' way to restart postgresql backends ( without stopping pgpool service ) which doesn't break the cluster. 

You can tweak health check parameters. For example,

health_check_max_retries = 10
health_check_retry_delay = 1

Also make sure that you restart PostgreSQL with "fast" mode.

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