I've already fixed it. I changed the data directory on pgsql resource because I'm using /usr/local/pgsql instead of /var/lib/pgsql
thanks! On Tue, Nov 30, 2010 at 6:00 PM, Andrew Beekhof <[email protected]> wrote: > On Tue, Nov 30, 2010 at 9:38 AM, Linux Cook <[email protected]> wrote: > > h > > > > Whats wrong with my configuration? > > No idea. Perhaps check out the new howto for postgres: > http://www.clusterlabs.org/wiki/PostgresHowto > > > DBIP: 10.110.10.5 > > drbd resource: postgres > > postgres service: postgresql > > node1: dmcs1 > > node2: dmcs2 > > > > > > $ crm configure show > > node dmcs1 > > node dmcs2 > > primitive DBIP ocf:heartbeat:IPaddr2 \ > > params ip="10.110.10.5" cidr_netmask="24" nic="eth3" \ > > op monitor interval="30s" > > primitive drbd_postgres ocf:linbit:drbd \ > > params drbd_resource="postgres" \ > > op monitor interval="15s" > > primitive postgres_fs ocf:heartbeat:Filesystem \ > > params device="/dev/drbd0" directory="/usr/local/pgsql" > > fstype="ext3" > > primitive postgresql ocf:heartbeat:pgsql \ > > op monitor interval="30" timeout="30" depth="0" \ > > meta target-role="Started" > > group postgres postgres_fs DBIP postgresql \ > > meta target-role="Started" > > ms ms_drbd_postgres drbd_postgres \ > > meta master-max="1" master-node-max="1" clone-max="2" > > clone-node-max="1" notify="true" > > colocation postgres_on_drbd inf: postgres ms_drbd_postgres:Master > > order postgres_after_drbd inf: ms_drbd_postgres:promote postgres:start > > property $id="cib-bootstrap-options" \ > > dc-version="1.0.9-74392a28b7f31d7ddc86689598bd23114f58978b" \ > > cluster-infrastructure="openais" \ > > expected-quorum-votes="2" \ > > stonith-enabled="false" \ > > no-quorum-policy="ignore" > > rsc_defaults $id="rsc-options" \ > > resource-stickiness="100" > > > > $ crm_verify -L > > crm_verify[7752]: 2010/11/30_16:38:25 ERROR: > create_notification_boundaries: > > Creating boundaries for ms_drbd_postgres > > crm_verify[7752]: 2010/11/30_16:38:25 ERROR: > create_notification_boundaries: > > Creating boundaries for ms_drbd_postgres > > crm_verify[7752]: 2010/11/30_16:38:25 ERROR: > create_notification_boundaries: > > Creating boundaries for ms_drbd_postgres > > crm_verify[7752]: 2010/11/30_16:38:25 ERROR: > create_notification_boundaries: > > Creating boundaries for ms_drbd_postgres > > > > $ crm_mon -1 > > ============ > > Last updated: Tue Nov 30 16:38:38 2010 > > Stack: openais > > Current DC: dmcs1 - partition with quorum > > Version: 1.0.9-74392a28b7f31d7ddc86689598bd23114f58978b > > 2 Nodes configured, 2 expected votes > > 2 Resources configured. > > ============ > > > > Online: [ dmcs1 dmcs2 ] > > > > Master/Slave Set: ms_drbd_postgres > > Masters: [ dmcs1 ] > > Slaves: [ dmcs2 ] > > Resource Group: postgres > > postgres_fs (ocf::heartbeat:Filesystem): Started dmcs1 > > DBIP (ocf::heartbeat:IPaddr2): Started dmcs1 > > postgresql (ocf::heartbeat:pgsql): Stopped > > > > Failed actions: > > postgresql_start_0 (node=dmcs1, call=19, rc=5, status=complete): not > > installed > > postgresql_start_0 (node=dmcs2, call=14, rc=5, status=complete): not > > installed > > > > $ cat /proc/drbd > > version: 8.3.7 (api:88/proto:86-91) > > srcversion: EE47D8BF18AC166BE219757 > > 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r---- > > ns:4 nr:12 dw:16 dr:297 al:1 bm:1 lo:0 pe:0 ua:0 ap:0 ep:1 wo:b oos:0 > > > > > > So the error is: pacemaker isn't starting postgresql service on node1. > > > > Please Help! > > > > Linuxcook > > _______________________________________________ > > Linux-HA mailing list > > [email protected] > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > See also: http://linux-ha.org/ReportingProblems > > > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
