Hi!
I have 3 nodes pgsql async cluster.
Now I want test it and reboot first node with pgsql master.
After reboot it migrate to secondarty node.
But after first node stay back - cluster is gone. Now I have this status:
Node Attributes:
* Node a.mydomain.com:
+ master-pgsql:0 : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-status : STOP
* Node c.mydomain.com:
+ master-pgsql:2 : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-master-baseline : 0000000028000090
+ pgsql-status : STOP
* Node b.mydomain.com:
+ master-pgsql:1 : -INFINITY
+ pgsql-data-status : LATEST
+ pgsql-status : STOP
Migration summary:
* Node a.mydomain.com:
pgsql:0: migration-threshold=1 fail-count=1
* Node b.mydomain.com:
pgsql:1: migration-threshold=1 fail-count=1
* Node c.mydomain.com:
pgsql:2: migration-threshold=1 fail-count=1
Failed actions:
pgsql:0_monitor_4000 (node=a.mydomain.com, call=27, rc=7,
status=complete): not running
pgsql:1_monitor_3000 (node=b.mydomain.com, call=165, rc=7,
status=complete): not running
pgsql:2_monitor_4000 (node=c.mydomain.com, call=44, rc=7,
status=complete): not running
So, I manual recovery repolicaton:
a node is master and b,c - slave.
But when I try change information via crm_attribute - nothing is changed:
crm_attribute -l forever -N a.mydomain.com -n "pgsql-data-status" -v
"LATEST"
crm_attribute -l forever -N b.mydomain.com -n "pgsql-data-status" -v "SYNC"
crm_attribute -l forever -N c.mydomain.com -n "pgsql-data-status" -v "SYNC"
How I can tell to cluster about a node is pgsql master?
_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
I have 3 nodes pgsql async cluster.
Now I want test it and reboot first node with pgsql master.
After reboot it migrate to secondarty node.
But after first node stay back - cluster is gone. Now I have this status:
Node Attributes:
* Node a.mydomain.com:
+ master-pgsql:0 : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-status : STOP
* Node c.mydomain.com:
+ master-pgsql:2 : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-master-baseline : 0000000028000090
+ pgsql-status : STOP
* Node b.mydomain.com:
+ master-pgsql:1 : -INFINITY
+ pgsql-data-status : LATEST
+ pgsql-status : STOP
Migration summary:
* Node a.mydomain.com:
pgsql:0: migration-threshold=1 fail-count=1
* Node b.mydomain.com:
pgsql:1: migration-threshold=1 fail-count=1
* Node c.mydomain.com:
pgsql:2: migration-threshold=1 fail-count=1
Failed actions:
pgsql:0_monitor_4000 (node=a.mydomain.com, call=27, rc=7,
status=complete): not running
pgsql:1_monitor_3000 (node=b.mydomain.com, call=165, rc=7,
status=complete): not running
pgsql:2_monitor_4000 (node=c.mydomain.com, call=44, rc=7,
status=complete): not running
So, I manual recovery repolicaton:
a node is master and b,c - slave.
But when I try change information via crm_attribute - nothing is changed:
crm_attribute -l forever -N a.mydomain.com -n "pgsql-data-status" -v
"LATEST"
crm_attribute -l forever -N b.mydomain.com -n "pgsql-data-status" -v "SYNC"
crm_attribute -l forever -N c.mydomain.com -n "pgsql-data-status" -v "SYNC"
How I can tell to cluster about a node is pgsql master?
_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems