{"action":"closed","issue":{"url":"https://api.github.com/repos/catarse/catarse/issues/1720","labels_url":"https://api.github.com/repos/catarse/catarse/issues/1720/labels{/name}","comments_url":"https://api.github.com/repos/catarse/catarse/issues/1720/comments","events_url":"https://api.github.com/repos/catarse/catarse/issues/1720/events","html_url":"https://github.com/catarse/catarse/issues/1720","id":103087751,"number":1720,"title":"heroku run rake db:migrate fails trying to create roles","user":{"login":"jeremysenn","id":197192,"avatar_url":"https://avatars.githubusercontent.com/u/197192?v=3","gravatar_id":"","url":"https://api.github.com/users/jeremysenn","html_url":"https://github.com/jeremysenn","followers_url":"https://api.github.com/users/jeremysenn/followers","following_url":"https://api.github.com/users/jeremysenn/following{/other_user}","gists_url":"https://api.github.com/users/jeremysenn/gists{/gist_id}","starred_url":"https://api.github.com/users/jeremysenn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeremysenn/subscriptions","organizations_url":"https://api.github.com/users/jeremysenn/orgs","repos_url":"https://api.github.com/users/jeremysenn/repos","events_url":"https://api.github.com/users/jeremysenn/events{/privacy}","received_events_url":"https://api.github.com/users/jeremysenn/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-25T18:28:25Z","updated_at":"2015-08-25T18:35:48Z","closed_at":"2015-08-25T18:35:47Z","body":"When trying to migrate the database for the first time on Heroku with \"heroku run rake db:migrate\", it fails trying to create roles:\r\n\r\nActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission denied to create role\r\nCONTEXT:  SQL statement \"CREATE ROLE postgrest NOLOGIN\"\r\n\r\nSince heroku does not allow the creation of roles, what is the best course of action to complete the migrations on heroku?"}}