apt-get install postgresql postgresql-client postgresql-contrib libpq-dev
gem install postgres
sudo gedit /etc/postgresql/8.4/main/pg_hba.conf
#update following codes
local all all auth
#to be
local all all md5
sudo /etc/init.d/postgresql-8.4 restart
sudo su - postgres
createuser -sPE mysuperuser