deploy_inital_wdchat_postgresql.yml
1.83 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
---
- hosts: deployed-wdchat-dma, deploy-wdchat-dma-single-host
become: true
tasks:
- name: Create Database WDCHAT & WDAUTHEN & USER
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=postgres -f /tmp/configuration/1_Create.User.sql
responses:
'Password for user postgres': 'password'
- name: Create WDCHAT Table
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/2_Create.WDCHAT.Table.sql
responses:
'Password for user wdchat': 'BBRyAPNh6g4H9qte'
- name: Initial WDCHAT
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdchat -d WDCHAT -f /tmp/configuration/3_Initial.WDCHAT.sql
responses:
'Password for user wdchat': 'BBRyAPNh6g4H9qte'
- name: Create WDAUTHEN Table
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/5_Create.WDAUTHEN.Table.sql
responses:
'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'
- name: Initial WDAUTHEN
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/6_Initial.WDAUTHEN.sql
responses:
'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'
- name: Alter WDAUTHEN, Patching version 3.0.4
expect:
command: /opt/stack/postgres/postgresql/bin/psql --host=127.0.0.1 --port=7432 --username=wdauthen -d WDAUTHEN -f /tmp/configuration/7_PatchWDAUTHEN.3.0.4.sql
responses:
'Password for user wdauthen': 'BBEcLWu5Cdzy3aeH'