On 13 June 2013 10:51, Takatoshi MATSUO <matsuo....@gmail.com> wrote:
> 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 > > Thank you. That change however didnt seem to have helped. I installed crmsh, and here's the config dump in crm format: node hanode01 node hanode02 node hanode03 primitive pgsql ocf:heartbeat:pgsql \ params pgctl="/usr/pgsql-9.2/bin/pg_ctl" psql="/usr/pgsql-9.2/bin/psql" pgdata="/var/lib/pgsql/9.2/data/" restore_command="cp /var/lib/pgsql/9.2/data/pg_archive/\%f \%p" start_opt="-p 5432" rep_mode="async" node_list="hanode01 hanode02" master_ip="10.0.1.100" stop_escalate="0" repuser="replicator" monitor_password="lemon31ee7" monitor_user="monitor" \ op start interval="0s" role="Master" timeout="60s" on-fail="block" primitive vip-master ocf:heartbeat:IPaddr2 \ params ip="10.0.0.100" nic="eth1:0" cidr_netmask="24" migration-threshold="0" \ op start interval="0s" timeout="60s" on-fail="block" primitive vip-rep ocf:heartbeat:IPaddr2 \ params ip="10.0.1.100" nic="eth2:0" cidr_netmask="24" migration-threshold="0" \ op start interval="0s" timeout="60s" on-fail="block" group master-group vip-master vip-rep ms msPostgresql pgsql \ meta master-max="1" master-node-max="1" clone-max="10" clone-node-max="1" notify="true" target-role="Master" location location-master-group-hanode01-5000 master-group 5000: hanode01 order order-master-group-msPostgresql-3 3: master-group:stop msPostgresql:demote symmetrical=false order order-msPostgresql-master-group-2 2: msPostgresql:promote master-group:start symmetrical=false property $id="cib-bootstrap-options" \ expected-quorum-votes="3" \ stonith-enabled="false" \ no-quorum-policy="ignore" rsc_defaults $id="rsc_defaults-options" \ resource-stickiness="INFINITY" \ migration-threshold="1" Attached are the logs from Today (I was changing the configuration, starting stoping, removing and readding things in the mean time). this is what I got after: grep pgsql /var/log/messages
pgsql_messages.log.gz
Description: GNU Zip compressed data
_______________________________________________ Pacemaker mailing list: Pacemaker@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
