On 27 Dec 2013, at 3:24 am, Andrey Rogovsky a.rogov...@gmail.com wrote:
This command help me.
I return pg cluster in normal state. Thanks a lot.
Now I was reboot a node for test and got this state:
Resource Group: master
pgsql-master-ip (ocf::heartbeat:IPaddr2): Started
This command help me.
I return pg cluster in normal state. Thanks a lot.
Now I was reboot a node for test and got this state:
Resource Group: master
pgsql-master-ip (ocf::heartbeat:IPaddr2): Started b.mydomain.com
Master/Slave Set: msPostgresql [pgsql]
Masters: [ b.mydomain.com ]
I usually do something like this on the master I want to bring up:
#!/bin/bash
rm -f /var/lib/pgsql/9.2/data/recovery.conf
rm -f ~postgres/tmp/PGSQL.lock
crm_attribute -l reboot -N $(uname -n) -n pgsql-data-status -v LATEST
crm_attribute -l reboot -N $(uname -n) -n master-pgsql -v 1000
crm
I run similar commands. But I have unwanted attributes and want to delete
they.
2013/12/25 Jeff Frost j...@pgexperts.com
I usually do something like this on the master I want to bring up:
#!/bin/bash
rm -f /var/lib/pgsql/9.2/data/recovery.conf
rm -f ~postgres/tmp/PGSQL.lock
So, does this not work:
crm_attribute -l reboot -N c.mydomain.com --name master-pgsql:2 --delete
?
On Dec 25, 2013, at 8:27 AM, Andrey Rogovsky a.rogov...@gmail.com wrote:
I run similar commands. But I have unwanted attributes and want to delete
they.
2013/12/25 Jeff Frost
On Dec 23, 2013, at 9:47 PM, Andrey Rogovsky a.rogov...@gmail.com wrote:
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
Thanks a lot! It really help me!
Now I have this status:
Node Attributes:
* Node a.mydomain.com:
+ master-pgsql:0 : 1000
+ master-pgsql:1 : -INFINITY
+ pgsql-data-status : LATEST
+ pgsql-master-baseline : 2F90
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
