role_zabbix/templates/create_db.j2

6 lines
283 B
Django/Jinja

DROP DATABASE IF EXISTS {{ db_name }};
DROP USER IF EXISTS {{ db_user }};
CREATE DATABASE {{ db_name }};
CREATE USER {{ db_user }} WITH ENCRYPTED PASSWORD '{{ db_passwd }}';
GRANT ALL PRIVILEGES ON {{ db_name }} TO {{ db_user }};
ALTER DATABASE {{ db_name }} OWNER TO {{ db_user }};