Search code examples
ruby-on-railsrubypostgresqlrake

Running a Rails app locally - creating local version of database schema with Rake failing

I have a rails app that I'm trying to run on my local machine that was developed else where, after battling a myriad of dependency issues, it seems like the last piece is the database not being locally installed, causing errors such as 

PG::UndefinedTable: ERROR:  relation "lessons" does not exist (ActiveRecord::StatementInvalid)

Whenever I try to do rake db:setup I get 

PG::InsufficientPrivilege: ERROR:  permission denied to create database

The database is a local Postgres db, I have made sure to create the user specified in database.yml, and Postgres is running.

Any ideas how I can get this app to run?

Solution

  • The PG permissions error was a separate problem, however the relations not found issue was fixed by simply creating the missing supporting table manually, and the rest of the db setup job completed successfully.