get_databases.sh

aws rds describe-db-instances | jq '.DBInstances[] | "" + .DBInstanceIdentifier + " " + .MasterUsername +   " " + .Endpoint.Address' -r | grep pro > hosts

init_dbs.sh

#!/bin/bash
set -e

DB_ID=$1
USER=$2
HOSTNAME=$3

PASS=`pwgen 10 1`
aws rds modify-db-instance --db-instance-identifier $DB_ID --master-user-password $PASS > /dev/null
CONNECTION_URL="postgres://${USER}:${PASS}@${HOSTNAME}/postgres"
echo "$CONNECTION_URL"
echo "Sleeping for 30s to make password change effective"
sleep 30
echo -e "CREATE DATABASE \"ad-manager\";\nGRANT ALL PRIVILEGES ON DATABASE \"ad-manager\" TO $USER;\nCREATE DATABASE pusher;\nGRANT ALL PRIVILEGES ON DATABASE pusher TO $USER;\nCREATE DATABASE settings;\nGRANT ALL PRIVILEGES ON DATABASE settings TO $USER;\nCREATE DATABASE content;\nGRANT ALL PRIVILEGES ON DATABASE content TO $USER;\n" | psql "${CONNECTION_URL}"