[Pacemaker] configuring postgresql streaming replication cluster

[Takatoshi MATSUO]

Hi

> As far the logs go, anything specific I should be grepping for ?

Please grep pgsql

> node_list="hanode01 hanode02" \

You need to add all node names whose replication is controlled by Pacemaker.

> pcs resource master msPostgresql pgsql master-max=1 master-node-max=1 clone-max=10 clone-node-max=10 notify=true

Why do you use clone-node-max=10 ?
Please use clone-node-max=1

> pcs constraint order start master-group  then promote msPostgresql   symmetrical=false score=2

You should start master-group after promote msPostgresql.

I am not good at pcs.
Please see https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication


In the beginning,I recommend you using 2 nodes.


Thanks,
Takatoshi

2013/6/13 Gregg Jaskiewicz <gryzman at gmail.com>:
>
>
>
> On 12 June 2013 06:59, Takatoshi MATSUO <matsuo.tak at gmail.com> wrote:
>>
>> Hi Gregg
>>
>> Can you show me the output of  "crm_mon -Afr" ?
>> And please see pacemaker log.
>> Pgsql RA may output some reasons why slave cann't be promoted.
>>
>
> Last updated: Thu Jun 13 08:06:26 2013
> Last change: Tue Jun 11 12:46:54 2013 via cibadmin on hanode01
> Stack: classic openais (with plugin)
> Current DC: hanode01 - partition with quorum
> Version: 1.1.8-7.el6-394e906
> 3 Nodes configured, 3 expected votes
> 14 Resources configured.
>
>
> Online: [ hanode01 hanode02 hanode03 ]
>
> Full list of resources:
>
>  Resource Group: master-group
>      vip-master (ocf::heartbeat:IPaddr2):       Started hanode01
>  Master/Slave Set: msPostgresql [pgsql]
>      Slaves: [ hanode01 hanode02 hanode03 ]
>      Stopped: [ pgsql:3 pgsql:4 pgsql:5 pgsql:6 pgsql:7 pgsql:8 pgsql:9 ]
>  Clone Set: vip-rep-clone [vip-rep]
>      Started: [ hanode01 hanode02 hanode03 ]
>
> Node Attributes:
> * Node hanode01:
>     + master-pgsql                      : -INFINITY
>     + pgsql-status                      : HS:alone
> * Node hanode02:
>     + master-pgsql                      : -INFINITY
>     + pgsql-status                      : HS:alone
> * Node hanode03:
>     + master-pgsql                      : -INFINITY
>     + pgsql-status                      : HS:alone
>
> Migration summary:
> * Node hanode01:
> * Node hanode02:
> * Node hanode03:
>
>
> As far the logs go, anything specific I should be grepping for ?
>
>
> --
> GJ
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>