Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - name: Меняем схему по умолчанию
- community.postgresql.postgresql_query:
- # host: "{{ PGSRV1 }}"
- db: "{{ item.name }}"
- login_user: "{{ item.user }}"
- login_password: "{{ PGPWD }}"
- query: ALTER DATABASE %s SET search_path TO %s
- positional_args:
- - '{{ item.name }}'
- - '{{ item.name }}'
- loop: "{{ dbname }}"
- dbname:
- - { name: "admin_api", user: "admin_api_admin" }
- - { name: "agenda", user: "agenda_admin" }
- - { name: "client_api", user: "client_api_admin" }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement