Change from SQLite to PostgreSQL in a fresh Rails project

by

You can change your database.yml to this instead of using the out of the box sqlite one:

development:
  adapter: postgresql
  encoding: utf8
  database: project_development
  pool: 5
  username: 
  password:

test: &TEST
  adapter: postgresql
  encoding: utf8
  database: project_test
  pool: 5
  username: 
  password:

production:
  adapter: postgresql
  encoding: utf8
  database: project_production
  pool: 5
  username: 
  password:

cucumber:
  <<: *TEST

More Related Contents:

  1. Deploying RoR app to Heroku with SQLite 3 fails
  2. PG::ConnectionBad – could not connect to server: Connection refused
  3. Postgres could not connect to server
  4. Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?
  5. Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)
  6. Heroku deployment failed because of sqlite3 gem error
  7. Cannot add a NOT NULL column with default value NULL in Sqlite3
  8. HEROKU – cannot run git push heroku master [duplicate]
  9. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  10. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  11. How do you write a case insensitive query for both MySQL and Postgres?
  12. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]
  13. Ignoring time zones altogether in Rails and PostgreSQL
  14. cannot load such file — sqlite3/sqlite3_native (LoadError) on ruby on rails
  15. Can’t find the PostgreSQL client library (libpq)
  16. PostgreSQL GROUP BY different from MySQL?
  17. Can not connect to local PostgreSQL
  18. Rails: Installing PG gem on OS X – failure to build native extension
  19. Alias for column names in Rails
  20. Clean way to find ActiveRecord objects by id in the order specified
  21. Rails 4 images not loading on heroku
  22. What is the best way to seed a database in Rails?
  23. Connecting to multiple databases in ruby on rails
  24. Why do people use Heroku when AWS is present? What distinguishes Heroku from AWS? [closed]
  25. A migration to add unique constraint to a combination of columns
  26. Convert SQLITE SQL dump file to POSTGRESQL
  27. Rails: PG::UndefinedTable: ERROR: relation “…” does not exist
  28. Rails + Postgres drop error: database is being accessed by other users
  29. How do I avoid a race condition in my Rails app?
  30. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?

Leave a Comment