Postgres Database Creation

database-creation-postgres.sh

#####################################################
### Setup database
#####################################################
# start your database as follows
sudo /etc/init.d/postgresql start
# create user
sudo -u postgres createuser -l -D -S -R sduser
# create database
sudo -u postgres createdb -O sduser successdart_development
sudo -u postgres createdb -O sduser successdart_test
# open postgresql console
sudo -u postgres psql
# and run these statements (note the trailing semi colon)
alter user sduser with encrypted password 'sduser';
alter user sduser createdb;
grant all privileges on database successdart_development to sduser;
grant all privileges on database successdart_test to sduser;

\l # show databases 
\q # for quitting the postgres console