Bash script for easy bootstrapping a PostgreSQL database

postgresbootstrap.sh

#!/bin/bash

make_database () {
    sudo -u postgres psql -d template1 -U postgres -c "CREATE USER $db_user WITH PASSWORD '$db_password';";
    sudo -u postgres psql -d template1 -U postgres -c "CREATE DATABASE $db_name;";
    sudo -u postgres psql -d template1 -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE $db_name to $db_user;";
    sudo service postgresql restart;
}

echo "Please enter a database user: "
read -e db_user
echo "You entered: $db_user"

echo "Please enter a database name: "
read -e db_name
echo "You entered: $db_name"

echo "Please enter a database password: "
read -e -s db_password
echo "You entered: $db_password"

while true; do
    echo "You selected database $db_name owned by user $db_user and your selected password."
    read -p "Do you wish to configure this database? (y/n) " yn
    case $yn in
        [Yy]* ) echo "configuring...."; make_database; break;;
        [Nn]* ) exit;;
        * ) echo "Please answer yes or no.";;
    esac
done