Just a reminder for postgres setup

postgres_setup.md

##Create a new user with super permission

su
sudo -u postgres psql
create user username with password 'password';
alter role username superuser createrole createdb replication;
create database projectname_production owner username;

Create new app using postgres (Rails 4.1.1)

###Local

rails new myapp --database=postgresql

###Remote

su
sudo -u postgres psql
create role myapp with createdb login password 'password1';
export MYAPP_DATABASE_PASSWORD='password1'

Useful Tips

###Get Role List

SELECT rolname FROM pg_roles;

###Drop Role

DROP ROLE myapp;