db.yml

- name: Update default locale to 'en_US.utf8'
  command: update-locale LC_ALL="en_US.utf8"
  sudo: True
  
  - name: Install db packages
  apt: pkg=$item state=installed
  with_items:
    - postgresql-9.1
    - postgresql-contrib-9.1
    - postgresql-server-dev-9.1
  sudo: True
  
  - name: Create ttwick database
  postgresql_db: db=xxx
                 encoding='utf8'
                 lc_collate='en_US.UTF-8'
                 lc_ctype='en_US.UTF-8'
                 template='template0'