[pgpool-general: 6589] Re: Problem with short pg server restart and pgpool failover

[Tatsuo Ishii]

> Hi,i have problem with doing short postgres servers (master or slave) restart without starting failover procedure from pgpool.I have 2 postgres servers (master and slave) and 2 pgpool. When I do a short simple restart postgres server (change some parameters that needed to restart pg), pgpool starting failover procedure without searching for nodes. In log there is :DETAIL:  postmaster on DB node 1 was shutdown by administrative commandI dont want to turning off pgpools to do postgres restart because this make more time to do this.Is there is possible to restart postgres without starting failover procedure from pgpool?? If no, maybe should it be new feature in new version of pgpool.... Best regardsRadoslaw Szczygiel--Pozdrawiam

You can avoid the failover before restarting PostgreSQL by doing followings:

- all clients get logout from Pgpool-II

- set health_check_peroiod to 0 and reload pgpool.conf (don't forget
  to recover it after you restart PostgreSQL server)
  
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp