Advertisement
k3NGuru

Untitled

Feb 19th, 2024
1,071
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
YAML 0.51 KB | None | 0 0
  1. - name: Меняем схему по умолчанию
  2.   community.postgresql.postgresql_query:
  3.    # host: "{{ PGSRV1 }}"
  4.     db: "{{ item.name }}"
  5.     login_user: "{{ item.user }}"
  6.     login_password: "{{ PGPWD }}"
  7.     query: ALTER DATABASE %s SET search_path TO %s
  8.     positional_args:
  9.    - '{{ item.name }}'
  10.     - '{{ item.name }}'
  11.   loop: "{{ dbname }}"
  12.  
  13. dbname:
  14. - { name: "admin_api", user: "admin_api_admin" }
  15. - { name: "agenda", user: "agenda_admin" }
  16. - { name: "client_api", user: "client_api_admin" }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement