Projet

Général

Profil

0001-use-postgres-user-to-create-postgres-role-and-db-282.patch

Emmanuel Cazenave, 22 novembre 2018 15:18

Télécharger (2,15 ko)

Voir les différences: 

Subject: [PATCH] use postgres user to create postgres role and db (#28231)

Also install postgresql package.

 clean.yml                      |  2 ++
 roles/app-setup/tasks/main.yml |  2 ++
 roles/base/tasks/main.yml      | 17 ++++++++++-------
 3 files changed, 14 insertions(+), 7 deletions(-)
clean.yml
77 77 
        name: "{{item.value.db_name}}"
78 78 
        state: absent
79 79 
      with_dict: "{{apps}}"
80 
      become: yes
81 
      become_user: postgres
80 82 

  		












  

    
      roles/app-setup/tasks/main.yml
    
  





  9
  9
  
    
  postgresql_db:

  		




  10
  10
  
    
    name: "{{db_name}}"

  		




  11
  11
  
    
    owner: "{{user}}"

  		




  
  12
  
    
  become: yes

  		




  
  13
  
    
  become_user: postgres

  		




  12
  14
  
    

  		




  13
  15
  
    
- name: "{{app_name}} - /var/lib directory"

  		




  14
  16
  
    
  file:

  		












  

    
      roles/base/tasks/main.yml
    
  





  1
  1
  
    
---

  		




  2
  
  
    
- name: Install system packages depedencies

  		




  
  2
  
    
- name: Install system packages dependencies

  		




  3
  3
  
    
  apt:

  		




  4
  4
  
    
    name: "{{ item }}"

  		




  5
  5
  
    
    state: present

  		




  6
  6
  
    
  with_items:

  		




  
  7
  
    
       - gettext

  		




  
  8
  
    
       - graphicsmagick

  		




  
  9
  
    
       - graphviz

  		




  7
  10
  
    
       - inkscape

  		




  
  11
  
    
       - libjs-leaflet

  		




  
  12
  
    
       - libjs-pdf

  		




  8
  13
  
    
       - libldap2-dev

  		




  9
  14
  
    
       - libsasl2-dev

  		




  10
  15
  
    
       - libssl-dev

  		




  11
  16
  
    
       - make

  		




  12
  17
  
    
       - nginx

  		




  
  18
  
    
       - postgresql

  		




  13
  19
  
    
       - python-dev

  		




  14
  20
  
    
       - python-lasso

  		




  15
  21
  
    
       - python-pip

  		




  16
  
  
    
       - python-virtualenv

  		




  17
  22
  
    
       - python-psycopg2

  		




  18
  
  
    
       - gettext

  		




  
  23
  
    
       - python-virtualenv

  		




  19
  24
  
    
       - rabbitmq-server

  		




  20
  25
  
    
       - ruby-sass

  		




  21
  26
  
    
       - supervisor

  		




  22
  
  
    
       - libjs-leaflet

  		




  23
  
  
    
       - libjs-pdf

  		




  24
  
  
    
       - graphicsmagick

  		




  25
  
  
    
       - graphviz

  		




  26
  27
  
    
  become: yes

  		




  27
  28
  
    

  		




  28
  29
  
    
- name: "create the postgresql user named {{user}}"

  		




  29
  30
  
    
  postgresql_user:

  		




  30
  31
  
    
    name: "{{user}}"

  		




  
  32
  
    
  become: yes

  		




  
  33
  
    
  become_user: postgres

  		




  31
  34
  
    

  		




  32
  35
  
    
- name: create the virtualenv and install django

  		




  33
  36
  
    
  pip:

  		




  34
  
  
    
-