Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication -

Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication -

i'm trying setup 2 node cluster postresql 9.3 , streaming replication. streaming replication configured. master hear , sending slave. can failover manually creating trigger file , failback master update info directory rsync, promote old master slave failover again.

at point, working fine.

now wanna setup automatic failover virtual (floating) ip pacemaker. master should have vip take client connections read , writes. if postgresql service master goes down, failover should triggered floating ip should moved slave (new master)

i seek next configuration guides https://github.com/t-matsuo/resource-agents/wiki/resource-agent-for-postgresql-9.1-streaming-replication https://github.com/t-matsuo/resource-agents/wiki unfortunately postgres not started pacemaker , vip-master assigned first started host.

my pacemaker configuration is:

property \ no-quorum-policy="ignore" \ stonith-enabled="false" \ crmd-transition-delay="0s" primitive pgsql ocf:heartbeat:pgsql \ params \ pgctl="/usr/bin/pg_ctlcluster" \ psql="/usr/bin/psql" \ pgdata="/database/postgresql/9.3/main/" \ start_opt="-p 5432" \ rep_mode="sync" \ node_list="robin marshall" \ restore_command="" \ primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5 keepalives_count=5" \ master_ip="172.16.1.1" \ stop_escalate="0" \ op start timeout="60s" interval="0s" on-fail="restart" \ op monitor timeout="60s" interval="5s" on-fail="restart" \ op monitor timeout="60s" interval="2s" on-fail="restart" role="master" \ op promote timeout="60s" interval="0s" on-fail="restart" \ op demote timeout="60s" interval="0s" on-fail="stop" \ op stop timeout="60s" interval="0s" on-fail="block" \ op notify timeout="60s" interval="0s" primitive pingcheck ocf:pacemaker:ping \ params \ name="default_ping_set" \ host_list="172.16.0.1" \ multiplier="100" \ op start timeout="60s" interval="0s" on-fail="restart" \ op monitor timeout="60s" interval="2s" on-fail="restart" \ op stop timeout="60s" interval="0s" on-fail="ignore" rsc_defaults \ resource-stickiness="infinity" \ migration-threshold="1" ms mspostgresql pgsql \ meta \ master-max="1" \ master-node-max="1" \ clone-max="2" \ clone-node-max="1" \ notify="true" primitive vip-master ocf:heartbeat:ipaddr2 \ params \ ip="172.16.1.1" \ nic="bond0" \ cidr_netmask="16" \ op start timeout="60s" interval="0s" on-fail="stop" \ op monitor timeout="60s" interval="2s" on-fail="restart" \ op stop timeout="60s" interval="0s" on-fail="block" primitive vip-slave ocf:heartbeat:ipaddr2 \ params \ ip="172.16.1.2" \ nic="bond0" \ cidr_netmask="16" \ meta \ resource-stickiness="1" \ op start timeout="60s" interval="0s" on-fail="restart" \ op monitor timeout="60s" interval="2s" on-fail="restart" \ op stop timeout="60s" interval="0s" on-fail="block" clone clnpingcheck pingcheck grouping master-group \ vip-master \ vip-rep location rsc_location-1 vip-slave \ rule 200: pgsql-status eq "hs:sync" \ rule 100: pgsql-status eq "pri" \ rule -inf: not_defined pgsql-status \ rule -inf: pgsql-status ne "hs:sync" , pgsql-status ne "pri" location rsc_location-2 mspostgresql \ rule -inf: not_defined default_ping_set or default_ping_set lt 100 colocation rsc_colocation-1 inf: mspostgresql clnpingcheck colocation rsc_colocation-2 inf: master-group mspostgresql:master order rsc_order-1 0: clnpingcheck mspostgresql order rsc_order-2 0: mspostgresql:promote master-group:start symmetrical=false order rsc_order-3 0: mspostgresql:demote master-group:stop symmetrical=false

the crm_mom -a console show me following:

last updated: wed oct 29 20:02:32 2014 lastly change: wed oct 29 19:51:36 2014 via crm_attribute on robin stack: corosync current dc: robin (739246346) - partition quorum version: 1.1.10-42f2063 2 nodes configured 7 resources configured online: [ robin ] offline: [ marshall ] vip-master (ocf::heartbeat:ipaddr2): started robin clone set: clnpingcheck [pingcheck] started: [ robin ] stopped: [ marshall ] node attributes: * node robin: + default_ping_set : 100 + pgsql-data-status : latest failed actions: pgsql_start_0 (node=robin, call=48, rc=5, status=complete, last-rc-change=wed oct 29 20:01:48 2014 , queued=19ms, exec=0ms ): not installed

i in syslog , see, psql has problems, can not guess is.

oct 29 20:00:40 robin crmd[14139]: warning: do_log: fsa: input i_dc_timeout crm_timer_popped() received in state s_pending oct 29 20:00:41 robin pgsql(pgsql)[14148]: info: configuration file /database/postgresql/9.3/main//postgresql.conf not readable during probe. oct 29 20:00:41 robin pgsql(pgsql)[14148]: info: don't check /database/postgresql/9.3/main/ during probe oct 29 20:00:42 robin pgsql(pgsql)[14148]: info: changing pgsql-data-status on : ->latest. oct 29 20:00:42 robin pgsql(pgsql)[14148]: warning: retrying(remain 86400). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:43 robin pgsql(pgsql)[14148]: warning: retrying(remain 86399). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:44 robin pgsql(pgsql)[14148]: warning: retrying(remain 86398). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:45 robin pgsql(pgsql)[14148]: warning: retrying(remain 86397). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:46 robin pgsql(pgsql)[14148]: warning: retrying(remain 86396). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:47 robin pgsql(pgsql)[14148]: warning: retrying(remain 86395). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:48 robin pgsql(pgsql)[14148]: warning: retrying(remain 86394). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:49 robin pgsql(pgsql)[14148]: warning: retrying(remain 86393). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:51 robin pgsql(pgsql)[14148]: warning: retrying(remain 86392). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:52 robin pgsql(pgsql)[14148]: warning: retrying(remain 86391). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:53 robin pgsql(pgsql)[14148]: warning: retrying(remain 86390). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:54 robin pgsql(pgsql)[14148]: warning: retrying(remain 86389). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:55 robin pgsql(pgsql)[14148]: warning: retrying(remain 86388). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:56 robin pgsql(pgsql)[14148]: warning: retrying(remain 86387). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:57 robin pgsql(pgsql)[14148]: warning: retrying(remain 86386). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:58 robin pgsql(pgsql)[14148]: warning: retrying(remain 86385). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:00:59 robin pgsql(pgsql)[14148]: warning: retrying(remain 86384). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:00 robin pgsql(pgsql)[14148]: warning: retrying(remain 86383). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:02 robin pgsql(pgsql)[14148]: warning: retrying(remain 86382). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:03 robin pgsql(pgsql)[14148]: warning: retrying(remain 86381). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:04 robin pgsql(pgsql)[14148]: warning: retrying(remain 86380). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:05 robin pgsql(pgsql)[14148]: warning: retrying(remain 86379). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:06 robin pgsql(pgsql)[14148]: warning: retrying(remain 86378). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:07 robin pgsql(pgsql)[14148]: warning: retrying(remain 86377). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:08 robin pgsql(pgsql)[14148]: warning: retrying(remain 86376). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:09 robin pgsql(pgsql)[14148]: warning: retrying(remain 86375). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:10 robin pgsql(pgsql)[14148]: warning: retrying(remain 86374). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:12 robin pgsql(pgsql)[14148]: warning: retrying(remain 86373). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:13 robin pgsql(pgsql)[14148]: warning: retrying(remain 86372). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:14 robin pgsql(pgsql)[14148]: warning: retrying(remain 86371). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:15 robin pgsql(pgsql)[14148]: warning: retrying(remain 86370). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:16 robin pgsql(pgsql)[14148]: warning: retrying(remain 86369). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:17 robin pgsql(pgsql)[14148]: warning: retrying(remain 86368). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:18 robin pgsql(pgsql)[14148]: warning: retrying(remain 86367). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:19 robin pgsql(pgsql)[14148]: warning: retrying(remain 86366). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:20 robin pgsql(pgsql)[14148]: warning: retrying(remain 86365). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:22 robin pgsql(pgsql)[14148]: warning: retrying(remain 86364). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:23 robin pgsql(pgsql)[14148]: warning: retrying(remain 86363). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:24 robin pgsql(pgsql)[14148]: warning: retrying(remain 86362). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:25 robin pgsql(pgsql)[14148]: warning: retrying(remain 86361). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:26 robin pgsql(pgsql)[14148]: warning: retrying(remain 86360). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:27 robin pgsql(pgsql)[14148]: warning: retrying(remain 86359). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:28 robin pgsql(pgsql)[14148]: warning: retrying(remain 86358). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:29 robin pgsql(pgsql)[14148]: warning: retrying(remain 86357). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:30 robin pgsql(pgsql)[14148]: warning: retrying(remain 86356). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:32 robin pgsql(pgsql)[14148]: warning: retrying(remain 86355). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:33 robin pgsql(pgsql)[14148]: warning: retrying(remain 86354). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:34 robin pgsql(pgsql)[14148]: warning: retrying(remain 86353). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:35 robin pgsql(pgsql)[14148]: warning: retrying(remain 86352). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:36 robin pgsql(pgsql)[14148]: warning: retrying(remain 86351). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:37 robin pgsql(pgsql)[14148]: warning: retrying(remain 86350). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:38 robin pgsql(pgsql)[14148]: warning: retrying(remain 86349). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:39 robin pgsql(pgsql)[14148]: warning: retrying(remain 86348). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:40 robin pgsql(pgsql)[14148]: warning: retrying(remain 86347). "exec_with_timeout 0 /usr/sbin/crm_attribute -l forever -n -n pgsql-data-status -v latest" failed. rc=22. stdout="non-option argv-elements: pgsql-data-status #012please take 1 of matches above , suppy 'id' --attr-id". oct 29 20:01:41 robin lrmd[14136]: warning: child_timeout_callback: pgsql_monitor_0 process (pid 14148) timed out oct 29 20:01:41 robin lrmd[14136]: warning: operation_finished: pgsql_monitor_0:14148 - timed out after 60000ms oct 29 20:01:41 robin crmd[14139]: error: process_lrm_event: lrm operation pgsql_monitor_0 (10) timed out (timeout=60000ms) oct 29 20:01:41 robin crmd[14139]: warning: status_from_rc: action 5 (pgsql:0_monitor_0) on robin failed (target: 7 vs. rc: 1): error oct 29 20:01:41 robin pengine[14138]: warning: unpack_rsc_op: processing failed op monitor pgsql:0 on robin: unknown error (1) oct 29 20:01:41 robin ipaddr2(vip-master)[14821]: info: adding ipv4 address 172.16.1.1/16 broadcast address 172.16.255.255 device bond0 oct 29 20:01:41 robin ipaddr2(vip-master)[14821]: info: bringing device bond0 oct 29 20:01:41 robin ipaddr2(vip-master)[14821]: info: /usr/lib/heartbeat/send_arp -i 200 -r 5 -p /var/run/resource-agents/send_arp-172.16.1.1 bond0 172.16.1.1 auto not_used not_used oct 29 20:01:48 robin pengine[14138]: warning: unpack_rsc_op: processing failed op monitor pgsql:0 on robin: unknown error (1) oct 29 20:01:48 robin crmd[14139]: warning: status_from_rc: action 10 (pgsql_start_0) on robin failed (target: 0 vs. rc: 5): error oct 29 20:01:48 robin crmd[14139]: warning: update_failcount: updating failcount pgsql on robin after failed start: rc=5 (update=infinity, time=1414609308) oct 29 20:01:48 robin crmd[14139]: warning: update_failcount: updating failcount pgsql on robin after failed start: rc=5 (update=infinity, time=1414609308) oct 29 20:01:48 robin pengine[14138]: warning: unpack_rsc_op: processing failed op start pgsql:0 on robin: not installed (5) oct 29 20:01:48 robin pengine[14138]: warning: common_apply_stickiness: forcing mspostgresql away robin after 1000000 failures (max=1) oct 29 20:01:48 robin pengine[14138]: warning: common_apply_stickiness: forcing mspostgresql away robin after 1000000 failures (max=1)

i'm not familiar pacemaker , pgslq.can help me or know error? maybe there solution automated failback or reattach if master or slave node comes back?

thanks lot

postgresql database-replication ubuntu-14.04 failover pacemaker