Postgresql with Ruby on Rails

Question

I want to migrate from sqlite3 to postgresql. After doing search I found that I should change my database.yml to somthing like that:

  adapter: postgresql
  encoding: unicode
  database: [insert your dev database name]
  pool: 5
  username: [insert your user name]
  password:

But I don't know what to provide in place of database, username and password. Because i don't remember creating any of them. I just created my rails app and migrations , and thats it.

Have you tried going to the postgres cli psql and type \du to show your roles? Then perform rake db:create? — Rod Argumedo
– Rod Argumedo, Commented Jun 16, 2015 at 4:32

Arivarasan L · Accepted Answer · 2015-06-16 04:35:18Z

2

To configure your rails project with postgres database do the below steps. provide your database details in the database.yml file eg:

development:
  username: postgres
  database: ur-db-dev
  password: pass
  encoding: UTF8
  adapter:  postgresql
  timeout:  500
  pool:     5

add postgres gem in your Gemfile

gem 'pg'

then,

Do bundle install to install postgres gem
rake db:create to create your database
rake db:migrate to migrate your migration files

answered Jun 16, 2015 at 4:35

Arivarasan L

10.1k2 gold badges42 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yerassyl Over a year ago

get an error "Couldn't create database for {"adapter"=>... etc} The question is where do i get that database name,username with password. Because it says that my password is wrong for user.

Arivarasan L Over a year ago

in psql you create a database and use it here or create a fresh database by your rails command rake db:create. Database user name, password is you configured when you installed your postgres. use this command and login into postgres to create new user with password psql -U postgres. For more info about psql user cyberciti.biz/faq/howto-add-postgresql-user-account

Collectives™ on Stack Overflow

Postgresql with Ruby on Rails

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related