Rails: permission denied for relation schema_migrations Rails: permission denied for relation schema_migrations postgresql postgresql

Rails: permission denied for relation schema_migrations


It seems you have to create a DB user with all needed privileges on your DB.For example I think you could do the trick by log in your DB console then do something like:

CREATE USER your_new_username WITH PASSWORD 'your_new_password';CREATE DATABASE whiteboard;GRANT ALL PRIVILEGES ON DATABASE whiteboard to your_new_username;ALTER DATABASE whiteboard OWNER TO your_new_username;

Then update you database.yml like this:

adapter: postgresqldatabase: whiteboardusername: your_new_usernamepassword: your_new_passwordpool: 5timeout: 5000

Hope it helps!