On Thu, May 19, 2011 at 5:05 AM, Eamon Roque <eamon.ro...@lex-com.net>wrote:
> Hi, > > I've put together a cluster of two nodes running a databank without shared > storage. Both nodes replicate data between them, which is taken care of by > the databank itself. > > I have a resource for the databank and ip. I then created a stateful clone > from the databank resource. I created colocation rules joining the > databank-ms-clone and ip: > > node pgsqltest1 > node pgsqltest2 > primitive Postgres-IP ocf:heartbeat:IPaddr2 \ > params ip="10.19.57.234" cidr_netmask="32" \ > op monitor interval="30s" \ > meta is-managed="false" > primitive resPostgres ocf:heartbeat:pgsql \ > params pgctl="/opt/PostgreSQL/9.0/bin/pg_ctl" > pgdata="/opt/PostgreSQL/9.0/data" psql="/opt/PostgreSQL/9.0/bin/psql" > pgdba="postgres" \ > op monitor interval="1min" \ > meta is-managed="false" > ms msPostgres resPostgres \ > meta master-max="1" master-node-max="1" clone-max="2" > clone-node-max="1" notify="true" target-role="started" > colocation colPostgres inf: Postgres-IP msPostgres:Master > order ordPostgres inf: msPostgres:promote Postgres-IP:start > property $id="cib-bootstrap-options" \ > dc-version="1.1.2-2e096a41a5f9e184a1c1537c82c6da1093698eb5" \ > cluster-infrastructure="openais" \ > expected-quorum-votes="2" \ > stonith-enabled="false" \ > no-quorum-policy="ignore" \ > last-lrm-refresh="1302707146" > rsc_defaults $id="rsc-options" \ > resource-stickiness="200" > op_defaults $id="op_defaults-options" \ > record-pending="false" > > The normal postgres agent doesn't support this functionality, but I've put > together my own using the mysql agent as a model. Before running the script > through ocf-tester, I unmanage the postgres resource. > Could you show how you implemented promote/demote for pgsql? > > Unfortunately, promote/demote doesn't work. ocf-tester tries to use the > "crm_attribute -N pgsql1 -n master-pgrql-replication-agent -l reboot -v > 100", but the (unmanaged) resources don't accept the score change. > > I'm pretty sure that I just need to be hit with a clue stick and would be > grateful for any help. > > Thanks, > > Éamon > > _______________________________________________ > 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://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker > > -- Serge Dubrouski.
_______________________________________________ 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://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker