#!/bin/bash -e

sudo su - postgres <<EOF

createdb tm351test

psql -q -c "CREATE USER test PASSWORD 'test';" tm351test
psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test;" tm351test

psql -q -c "CREATE USER test1 PASSWORD 'test1';" tm351test
psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test1;" tm351test

psql -q -c "CREATE USER test2 PASSWORD 'test2';" tm351test
psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test2;" tm351test

psql -q -c "CREATE USER logme PASSWORD 'logme';" tm351test
psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO logme;" tm351test
psql -q -c "ALTER USER logme SET log_statement='all';" tm351test

EOF

touch /root/postgresql.done