deploy_patch_psql_wdchat_wdauthen.yml

---
- hosts: deployed-wdchat-dma, deploy-wdchat-dma-single-host
  become: true
  tasks:
    
    - name: Patch WDCHAT 304 20171129
      expect: 
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/Patch_304_20171128_psql_WDCHAT.sql
        responses:
            'Password for user wdchat': 'BBRyAPNh6g4H9qte'
    
    - name: Patch WDAUTHEN 304 20171129
      expect:
        command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/Patch_304_20171128_psql_WDAUTHEN.sql
        responses:
            'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'
    

            
# update