railsしりとり PostgreSQLにきりかえ
SHOKAI-MAG /home/sho/src/shiritori% sudo -u postgres createuser shiritori_user -P [sudo] password for sho: Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE SHOKAI-MAG /home/sho/src/shiritori% sudo -u postgres createdb shiritori_dev -O shiritori_user CREATE DATABASE SHOKAI-MAG /home/sho/src/shiritori% sudo -u postgres createdb shiritori_test -O shiritori_user CREATE DATABASE SHOKAI-MAG /home/sho/src/shiritori% sudo -u postgres createdb shiritori_product -O shiritori_user CREATE DATABASE
sudo emacs /etc/postgresql/8.2/main/pg_hba.conf
local all all trust
sudo /etc/init.d/postgresql-8.2 restart
config/database.yml
# SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: postgresql database: shiritori_dev username: shiritori_user password: shiritori_pass timeout: 5000 # Warning: The database defined as 'test' will be erased and # re-generated from your development database when you run 'rake'. # Do not set this db to the same as development or production. test: adapter: postgresql database: shiritori_test username: shiritori_user password: shiritori_pass timeout: 5000 production: adapter: postgresql database: shiritori_product username: shiritori_user password: shiritori_pass timeout: 5000