MacOSX YosemiteでRails4.xを動かして、Postgresと繋げるときのメモ ref: http://qiita.com/tsumekoara/items/1c19052360864204c4f1

database.yml

default: &default
#  adapter: mysql2
  adapter: postgresql
  encoding: utf8
  pool: 5
#  username: root
  username: hoge
  password:
#  socket: /tmp/mysql.sock

development:
  <<: *default
  database: hoge_development

test:
  <<: *default
  database: hoge_test

production:
  <<: *default
  database: hoge_production
  password: <%= ENV['HOGE_DATABASE_PASSWORD'] %>

file10.txt

postgres=# create role hoge createdb replication superuser createrole login

file11.txt

postgres=# \du
                             List of roles
 Role name |                   Attributes                   | Member of
-----------+------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication | {}
 hoge      | Superuser, Create role, Create DB, Replication | {}

file12.txt

$ rake db:create

file13.txt

Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"utf8", "pool"=>5, "username"=>"hoge", "password"=>nil, "database"=>"hoge_development"}
PG::InsufficientPrivilege: ERROR:  permission denied to create database
: CREATE DATABASE "matcha_test" ENCODING = 'utf8'

file14.txt

$ sudo -u postgres -iPassword:
postgres$ psql
psql (9.4.1, server 9.4.0)
Type "help" for help.

postgres=# \l
                                 List of databases
        Name        |  Owner   | Encoding | Collate | Ctype |   Access privileges
--------------------+----------+----------+---------+-------+-----------------------
 hoge_development   | hoge     | UTF8     | C       | C     |
 hoge_test          | hoge     | UTF8     | C       | C     |

file15.txt

$ psql -U hoge -d hoge_development
psql (9.4.1, server 9.4.0)
Type "help" for help.

hoge_development=>

file16.txt

$ rails dbpsql (9.4.1, server 9.4.0)
Type "help" for help.

hoge_development=>

file17.txt

$ rake db:migrate

file18.txt

$ rails c

file19.txt

$ rails c

file3.txt

$ rails s
=> Booting WEBrick
=> Rails 4.2.0 application starting in development on http://localhost:3000
=> Run `rails server -h` for more startup options
=> Ctrl-C to shutdown server
Exiting
bin/rails:6: warning: already initialized constant APP_PATH
/Users/hoge/bin/rails:6: warning: previous definition of APP_PATH was here
Usage: rails COMMAND [ARGS]

The most common rails commands are:
 generate    Generate new code (short-cut alias: "g")
 console     Start the Rails console (short-cut alias: "c")
 server      Start the Rails server (short-cut alias: "s")
 dbconsole   Start a console for the database specified in config/database.yml
             (short-cut alias: "db")
 new         Create a new Rails application. "rails new my_app" creates a
             new application called MyApp in "./my_app"

In addition to those, there are:
 destroy      Undo code generated with "generate" (short-cut alias: "d")
 plugin new   Generates skeleton for developing a Rails plugin
 runner       Run a piece of code in the application environment (short-cut alias: "r")

All commands can be run with -h (or --help) for more information.

file4.txt

$ rake rails:update:bin

file5.txt

$ bin/spring binstub --remove --all

# GemfileからSpringの部分をコメントアウトして
$ bundle install

file6.txt

$ rails db
psql: FATAL:  role "hoge" does not exist

file7.txt

$ sudo su - postgres
or 
$ sudo -u postgres -i

file8.txt

postgres$ psql
psql (9.4.1, server 9.4.0)
Type "help" for help.

file9.txt

postgres-# \du
                             List of roles
 Role name |                   Attributes                   | Member of
-----------+------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication | {}

Gemfile

#gem 'mysql2'
gem 'pg'
gem 'rails_12factor', group: :production