ubuntu9.10+rails2.3.5+postgresql8.4的靠谱配置

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