Issue
User does not have CONNECT privilege
is shown in the build logs or postdeploy
output.
Resolution
We typically see CONNECT
privilege errors in cases where applications try to create databases as part of running db:setup
, given that the Heroku Postgres credential provided does not have privileges to create or drop databases.
For Rails apps, you should look to use db:schema:load
or db:migrate
instead of db:setup
.