Turn off self-healing
Execute stop doctor;in adbmgr to shut down self-healing.
postgres=# stop doctor;
NOTICE: Update pgxc_node successfully in 'gcn1'.
NOTICE: Update pgxc_node successfully in 'cn1'.
NOTICE: Update pgxc_node successfully in 'cn2'.
NOTICE: Update pgxc_node successfully in 'cn3'.
NOTICE: Update pgxc_node successfully in 'cn4'.
NOTICE: Updating pgxc_node successfully at all datanode master.
mgr_doctor_stop
-----------------
t
(1 row)
postgres=# list doctor;
type | subtype | key | value | comment
-----------+-----------------+----------------+-------+--------------------------------------------------------------------------------------------------------------
PARAMETER | -- | enable | 0 | 0:false, 1:true. If true, doctor processes will be launched, or else, doctor processes exit.
PARAMETER | -- | forceswitch | 1 | 0:false, 1:true. Whether force to switch the master/slave, note that force switch may cause data loss.
PARAMETER | -- | switchinterval | 10 | In seconds, The time interval for doctor retry the switching if an error occurred in the previous switching.
PARAMETER | -- | nodedeadline | 10 | In seconds. The maximum time for doctor tolerate a NODE running abnormally.
PARAMETER | -- | agentdeadline | 5 | In seconds. The maximum time for doctor tolerate a AGENT running abnormally.
NODE | gtmcoord master | gcn1 | t | enable doctor
NODE | gtmcoord slave | gcn2 | t | enable doctor
NODE | coordinator | cn1 | t | enable doctor
NODE | coordinator | cn2 | t | enable doctor
NODE | coordinator | cn3 | t | enable doctor
NODE | datanode master | dn1_1 | t | enable doctor
NODE | datanode master | dn2_1 | t | enable doctor
NODE | datanode master | dn3_1 | t | enable doctor
NODE | datanode slave | dn1_2 | t | enable doctor
NODE | datanode slave | dn1_3 | t | enable doctor
NODE | datanode slave | dn2_2 | t | enable doctor
NODE | datanode master | dn4_1 | t | enable doctor
NODE | coordinator | cn4 | t | enable doctor
NODE | datanode slave | dn3_2 | t | enable doctor
NODE | datanode slave | dn4_2 | t | enable doctor
HOST | -- | adb01 | t | enable doctor
HOST | -- | adb02 | t | enable doctor
(22 rows)
[antdb@intel175 ~]$ ps xuf|grep doctor
antdb 2435 0.0 0.0 112716 984 pts/46 S+ 16:09 0:00 | \_ grep --color=auto doctor
After stop execution, theenable parameter ofdoctor is 0 and there is no more doctor process.