[pgpool-general: 2229] Mistake with old master and new master
Lazaro Ruben Garcia Martinez
lgarciam at vnz.uci.cu
Tue Nov 5 14:17:21 JST 2013
Hello everyone in the list:
I have a mistake or a wrong knowledge about the meaning of old master and new master.
I have two nodes, node A and node B, node A is standby and node B is primary:
The pgpool.conf looks like this:
backend_hostname0 = A
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/opt/pgsql/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_hostname1 = B
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/opt/pgsql/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
When node B (primary) goes down the failover command is executed like this:
failover_command = '/opt/pgpool/bin/failover_stream.sh %M %m %H'
But in pgpool.log, old master node and new master node are the same:
2013-11-04 19:05:54 LOG: pid 15061: execute command: /opt/pgpool/bin/failover_stream.sh 0 0 A
The question is:
Why old master is 0 if node B is the node number 1 in pgpool.conf (backend_hostname1)?????
The pgpool version is 3.3.1.
Is this a bug??
Any help is appreciated.
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
More information about the pgpool-general