summaryrefslogtreecommitdiff
path: root/openstack/usr/share/openstack/postgres.yml
blob: 5ff9355e6094ed695e302d0bce1e21c73228a598 (plain)
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
39
40
41
42
43
44
45
46
47
48
---
- hosts: localhost
  vars_files:
  - "/etc/openstack/postgres.conf"
  tasks:

  - name: Create postgres user
    user:
        name: postgres
        comment: PostgreSQL Server
        shell: /sbin/nologin
        home: /var/lib/pgsql

  - name: Create the postgres directories
    file:
        path: "{{ item }}"
        state: directory
        owner: postgres
        group: postgres
    with_items:
    - /var/run/postgresql
    - /var/lib/pgsql/data

  - name: Initialise postgres database
    command: pg_ctl -D  /var/lib/pgsql/data initdb
    args:
        creates: /var/lib/pgsql/data/base
    sudo: yes
    sudo_user: postgres

  - name: Add the configuration needed for postgres for Openstack
    template:
        src: /usr/share/openstack/postgres/{{ item }}
        dest: /var/lib/pgsql/data/{{ item }}
        owner: postgres
        group: postgres
        mode: 0600
    with_items:
    - postgresql.conf
    - pg_hba.conf

  - name: Enable and start postgres services
    service:
        name: "{{ item }}"
        enabled: yes
        state: started
    with_items:
    - postgres-server