Sha256: 8414f57a0c7501d05278673ca7aa0d93cb81d50caac4a0a6ca4f6e41f6bce857
Contents?: true
Size: 1.3 KB
Versions: 13
Compression:
Stored size: 1.3 KB
Contents
---
- name: install dependencies
action: apt pkg={{item}} state=latest
with_items:
- python-apt
- python-psycopg2
- libpq-dev
- name: get postgres apt key
apt_key: url=http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc
- name: add apt-get repository for latest postgres
apt_repository: repo="deb http://apt.postgresql.org/pub/repos/apt/ {{ansible_lsb.codename}}-pgdg main"
- name: install postgres
apt: name=postgresql-{{postgresql_version}} state=latest update_cache=true
- name: copy pg_hba.conf
sudo: true
template: src=pg_hba.conf dest=/etc/postgresql/{{postgresql_version}}/main/pg_hba.conf
- name: set pg_hba.conf permissions
sudo: true
file: path=/etc/postgresql/{{postgresql_version}}/main/pg_hba.conf owner=postgres group=postgres mode=0640
- name: start postgresql
service: name=postgresql state=started
- name: create db user
postgresql_user: name={{database_user}} password={{database_password}} role_attr_flags=CREATEDB
sudo_user: postgres
- name: create database
postgresql_db: name={{database_name}} owner={{database_user}} encoding=unicode lc_collate=en_US.utf8 lc_ctype=en_US.utf8 template=template0
sudo_user: postgres
when: inventory_hostname == 'deploy'
- name: ensure postgres starts on a fresh reboot
service: name=postgresql state=started enabled=yes
Version data entries
13 entries across 13 versions & 2 rubygems