Setup postgresql for Rails testing on Ubuntu

postgresql_setup.sh

# TODO: 
# apt-get install Postgresql
# gem install postgresql
#
# ..more stuff...

#
# Make sure that your postgres account has
# superuser privileges, so "rake postgresql:build_databases"
# works properly
#
sudo -u postgres createuser --superuser $USER


# Use this command to drop into postgres command line
sudo su postgres -c psql

# To delete a user, drop into the console and run 'DROP USER <username>'
# http://www.postgresql.org/docs/7.3/static/sql-dropuser.html

# To delete a database, you can run 'DROP DATABASE <database-name>'
# http://www.postgresql.org/docs/8.2/interactive/sql-dropdatabase.html