Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---
- - hosts: kmt
- become_user: root
- become: yes
- gather_facts: no
- remote_user: vagrant
- tasks:
- - name: Install postgres database
- apt:
- name: "{{item}}"
- state: installed
- with_items:
- - postgresql
- - libpq-dev
- - python-psycopg2
- - hosts: kmt
- become: yes
- become_user: postgres
- gather_facts: no
- vars:
- dbname: kmt_prod
- dbuser: nguyenvinhlinh
- dbpassword: nguyenvinhlinh
- tasks:
- - name: make database
- postgresql_db: name={{dbname}}
- - name: ensure user has access to database
- postgresql_user: db={{dbname}} name={{dbuser}} password={{dbpassword}} priv=ALL
- - name: ensure user does not have unnecessary privilege
- postgresql_user: name={{dbuser}} role_attr_flags=NOSUPERUSER,NOCREATEDB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement