- hosts: all remote_user: ansible vars: store_env: "{{ store|default('1') }}" target_env: "{{ target|default('/opt/back/internal/postgres/') }}" extra_args: "{{ arg|default('--exclude-table=tbl_event --format=custom') }}" tasks: - debug: var: store_env - debug: var: target_env - name: Add num_of_days days to start_date command: date +'%Y-%m-%d' -d "+{{store_env}} days" register: end_date - debug: var: end_date.stdout - name: Dump the "{{ dbname }}" database to a file become: yes become_method: sudo become_user: postgres community.postgresql.postgresql_db: name: "{{ dbname }}" state: dump target: "{{ target_env }}{{ dbname }}_{{ ansible_date_time.date }}_{{ end_date.stdout }}.bak" dump_extra_args: "{{ extra_args }}"