[pgpool-general: 1519] pcp_detach_node isn't detaching the node

David Kerr web at mr-paradox.net
Fri Mar 22 06:07:24 JST 2013

This is 3.2.2 on linux.

i'm trying to detach a slave node. 

pcp_detach_node -d 10 localhost 9898 user password 1

DEBUG: send: tos="R", len=46
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="d", len=20, data=CommandComplete
DEBUG: send: tos="X", len=4

But when i connect it's still sending queries to the node.

backend_hostname0 = master
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/db/pg'
backend_flag0 = 'DISALLOW_TO_FAILOVER'

backend_hostname1 = slave
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/db/pg'
backend_flag1 = 'DISALLOW_TO_FAILOVER'

I wonder if it's the DISALLOW_TO_FAILOVER, or the fact that the master
is backend_weight0=0?


More information about the pgpool-general mailing list