Hello World from OSS Silicon Valley

• List of Backups
• View the diff.
• View the diff current.
• View the source.
• Go to HowToUse/RubyOnRails/4.2/PostgreSQL/9.3.
  • 1 (2015-09-25 (Fri) 02:09:06)
  • 2 (2015-09-25 (Fri) 02:59:02)
  • 3 (2015-09-25 (Fri) 21:25:42)

---

_ Prerequisite

• Ruby On Rails installation (You can refer HowToUse/RubyOnRails/4.1)
• PostgreSQL installation (You can refer HowToUse/PostgreSQL/9.3)

_ Install&Setup

Step.1

Check the version of installed postgresql.

$ su - postgres
$ psql --version

Step.2

Install module.

$ sudo apt-get install postgresql-server-dev-9.3

Step.3

Create rails project.

$ rails new <project name> --database=postgresql

Step.4

Edit Gemfile.

$ vi Gemfile

gem pg

Step.5

Install gems.

$ bundle install

Step.6

Update pg_hba.conf from "peer" to "trust" so that other user than postgres can access database as exepected.

$ su - postgres
$ cd /etc/postgres/9.3/main
$ vi pg_hba.conf

local   all             postgres                                trust
local   all             all                                     trust

Step.7

Restart postgres daemon.

$ /etc/init.d/postgres restart

Step.8

Create DB user for application.

$ su - postgres
$ psql -d postgres
postgres=# create role <user_name> login createdb;
postgres=# \q

Step.9

Edit database configuration for rails application. Put the same user name as you created in postgres database.

$ vi config/database.yml

default:
...
username: <user_name>

Step.10

Check if you can connect database from your rails application's user.

$ rails dbconsole

Step.11

Create and migrate initial database.

$ rake db:create
$ rake db:migrate

_ HowToUse

Step.1

xxx

_ Author

S.Yatsuzuka