Advertisement
Guest User

Untitled

a guest
Dec 17th, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. #!/bin/sh -x
  2. # Execute command by failover.
  3. # special values: %d = node id
  4. # %h = host name
  5. # %p = port number
  6. # %D = database cluster path
  7. # %m = new master node id
  8. # %M = old master node id
  9. # %H = new master node host name
  10. # %P = old primary node id
  11. # %% = '%' character
  12. failed_node_id=$1
  13. failed_host_name=$2
  14. failed_port=$3
  15. failed_db_cluster=$4
  16. new_master_id=$5
  17. old_master_id=$6
  18. new_master_host_name=$7
  19. old_primary_node_id=$8
  20. PGDATA="/var/lib/pgsql/10/data"
  21.  
  22. if [ $failed_node_id = $old_primary_node_id ];then # master failed
  23. sshpass -p root ssh -T postgres@$new_master_host_name $PGDATA/promote.sh
  24. fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement