[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.
Regards.

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com


More information about the pgpool-general mailing list