include:
  - db
  - web

web_down_before_database_reload:
  service:
  - name: apache22
  - dead
  - prereq:
    - cmd: database_reload

web_up_after_database_reload:
  service:
  - name: apache22
  - running
  - require:
    - cmd: database_reload

database_reload:
  cmd.run:
    - name: |
        psql template1 drop database neil2
        ssh maayan.insightcruises.com pg_dump -C neil2 | psql template1
    - require:
      - service: postgresql