ansible and postgres starting and stopping

gistfile1.txt

# handy for waiting for postgres to restore/catch up to master

- name: wait for db to come up
  shell:  until /usr/bin/pg_isready; do sleep 1; done
  args:
    executable: /bin/bash
  changed_when: false
  delegate_to: "{{ database_host }}"
  become_user: postgres
  run_once: true

# handy when waiting for postgres to shutdown so you can restore a wal-e backup
- name: wait for db to stop
  shell:  while /usr/bin/pg_isready; do sleep 1; done
  args:
    executable: /bin/bash
  changed_when: false
  delegate_to: "{{ database_host }}"
  become_user: postgres
  run_once: true