postgresql/roles/postgresql/templates/risotto_backup.j2

12 lines
356 B
Django/Jinja

#!/bin/bash -e
rm -rf {{ backup_dir }}
mkdir -p {{ backup_dir }}
chown postgres: {{ backup_dir }}
{%- for server in accounts.remotes -%}
{%- set name = server|normalize_family -%}
{%- set database = accounts["remote_" + name].database %}
su -c "pg_dump -F c -b -v -f {{ backup_dir }}/{{ database }}.dump {{ database }}" postgres
{%- endfor %}
exit 0