postgres.yml

---
- name: "add postgres repository"
  sudo: yes
  apt_repository: repo="deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"


- name: "add postgres repository key"
  sudo: yes
  apt_key: url="https://www.postgresql.org/media/keys/ACCC4CF8.asc"


- name: "install postgres & libpq-dev"
  sudo: yes
  apt: name="{{ item }}" update_cache=yes state=present
  with_items:
    - postgresql-9.4
    - libpq-dev


- name: install psycopg2 python module
  sudo: yes
  pip: name=psycopg2


- name: create postgres user for deployer
  postgresql_user:
    name: "{{ deployer }}"
    password: "{{ database_password }}"
    role_attr_flags: CREATEDB,SUPERUSER
  sudo: yes
  sudo_user: postgres


- name: "create database"
  postgresql_db: name="{{ database_name }}" encoding="UTF-8"
  sudo: yes
  sudo_user: postgres