# Check that user credentials for backup is set

[[ -v POSTGRESQL_BACKUP_USER && -v POSTGRESQL_BACKUP_PASSWORD ]] || usage "You have to set all variables for user for doing backup: POSTGRESQL_BACKUP_USER, POSTGRESQL_BACKUP_PASSWORD"

# create backup user with 'backup' database
psql --variable=user="$POSTGRESQL_BACKUP_USER" \
     --variable=password="$POSTGRESQL_BACKUP_PASSWORD" \
     <<<"
CREATE USER :user SUPERUSER  password :'password';
CREATE DATABASE backup OWNER = :user;
ALTER USER :user set default_transaction_read_only = on;
"