diff options
Diffstat (limited to 'roles/postgres/tasks/main.yml')
-rw-r--r-- | roles/postgres/tasks/main.yml | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/roles/postgres/tasks/main.yml b/roles/postgres/tasks/main.yml index 8c6218ff..8aa46063 100644 --- a/roles/postgres/tasks/main.yml +++ b/roles/postgres/tasks/main.yml @@ -1,5 +1,5 @@ --- -# Need to always define 'sudo_user: postgres' or it will not work! +# Need to always define 'become_user: postgres' or it will not work! - name: Install packages apt: pkg={{item}} state=installed update-cache=yes @@ -20,7 +20,7 @@ service: name=postgresql state=started enabled=yes - name: Create postgres user - sudo_user: postgres + become_user: "postgres" postgresql_user: user={{db_user}} password={{db_password}} role_attr_flags=CREATEDB,NOSUPERUSER @@ -28,7 +28,7 @@ - database - name: Create postgres database - sudo_user: postgres + become_user: "postgres" postgresql_db: name={{db_name}} owner={{db_user}} template=template0 @@ -39,8 +39,7 @@ - name: Alter postgresql database template for extension hstore command: psql {{db_name}} -c 'create extension if not exists hstore;' register: psql_hstore - sudo: yes - sudo_user: postgres + become_user: "postgres" ignore_errors: True changed_when: not psql_hstore.stderr when: settings_hstore_extension is defined and setting_hstore_extension == true |