ansible-role-epas-teleworker/templates/pg-create-user-db.sh.j2

13 lines
467 B
Django/Jinja

#!/bin/bash
set -e
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
CREATE USER {{ epas_teleworker_db_user }} password '{{ epas_teleworker_db_password }}';
CREATE DATABASE {{ epas_teleworker_db_name }}
OWNER {{ epas_teleworker_db_user }}
ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8'
TEMPLATE template0;
GRANT ALL PRIVILEGES ON DATABASE {{ epas_teleworker_db_name }} TO {{ epas_teleworker_db_user }};
EOSQL