Advertisement
Guest User

Untitled

a guest
Nov 19th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.29 KB | None | 0 0
  1. pcs cluster cib pgsql_cfg
  2.  
  3. pcs -f pgsql_cfg property set no-quorum-policy="ignore"
  4. pcs -f pgsql_cfg property set stonith-enabled="false"
  5. pcs -f pgsql_cfg resource defaults resource-stickiness="INFINITY"
  6. pcs -f pgsql_cfg resource defaults migration-threshold="1"
  7.  
  8. pcs -f pgsql_cfg resource create vip-master IPaddr2 \
  9. ip="172.29.10.3" \
  10. nic="ens32" \
  11. cidr_netmask="24" \
  12. op start timeout="60s" interval="0s" on-fail="restart" \
  13. op monitor timeout="60s" interval="10s" on-fail="restart" \
  14. op stop timeout="60s" interval="0s" on-fail="block"
  15.  
  16. pcs -f pgsql_cfg resource create vip-rep IPaddr2 \
  17. ip="172.29.10.5" \
  18. nic="ens32" \
  19. cidr_netmask="24" \
  20. meta migration-threshold="0" \
  21. op start timeout="60s" interval="0s" on-fail="stop" \
  22. op monitor timeout="60s" interval="10s" on-fail="restart" \
  23. op stop timeout="60s" interval="0s" on-fail="ignore"
  24.  
  25. pcs -f pgsql_cfg resource create pgsql pgsql \
  26. pgctl="/opt/pgpro/ent-10/bin/pg_ctl" \
  27. psql="/opt/pgpro/ent-10/bin/psql" \
  28. pgdata="/var/lib/pgpro/ent-10/data/" \
  29. rep_mode="sync" \
  30. node_list="node1 node2" \
  31. restore_command="cp /var/lib/pgpro/ent-10/pg_archive/%f %p" \
  32. primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5 keepalives_count=5" \
  33. master_ip="172.29.10.5" \
  34. restart_on_promote='false' \
  35. op start timeout="60s" interval="0s" on-fail="restart" \
  36. op monitor timeout="60s" interval="4s" on-fail="restart" \
  37. op monitor timeout="60s" interval="3s" on-fail="restart" role="Master" \
  38. op promote timeout="60s" interval="0s" on-fail="restart" \
  39. op demote timeout="60s" interval="0s" on-fail="stop" \
  40. op stop timeout="60s" interval="0s" on-fail="block" \
  41. op notify timeout="60s" interval="0s"
  42.  
  43. pcs -f pgsql_cfg resource master msPostgresql pgsql master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 notify=true
  44.  
  45. pcs -f pgsql_cfg resource group add master-group vip-master vip-rep
  46.  
  47. pcs -f pgsql_cfg constraint colocation add master-group with Master msPostgresql INFINITY
  48. pcs -f pgsql_cfg constraint order promote msPostgresql then start master-group symmetrical=false score=INFINITY
  49. pcs -f pgsql_cfg constraint order demote msPostgresql then stop master-group symmetrical=false score=0
  50.  
  51. pcs cluster cib-push cib pgsql_cfg
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement