postgres init user

# install POSTGRES
# remove password for localhost
# Update localhost and 127.0.0.1 to trust
# add the following lines to /etc/postgresql/9.3/main/pg_hba.conf in the hosts part
# make sure there are no other localhost or 127.0.0.1 lines
host    all             all             127.0.0.1               trust
host    all             all             localhost               trust

sudo vim /etc/postgresql/9.3/main/pg_hba.conf



# fix max_prepared_transactions 
# edit /etc/postgresql/9.3/main/postgresql.conf
# change max_prepared_transactions to 10

sudo /etc/init.d/postgresql restart
sudo -u postgres createuser --superuser $USERNAME
createdb $USERNAME
# sudo -u postgres psql