Why am I seeing "User does not have CONNECT privilege" error with Heroku Postgres on Review Apps?


We typically see CONNECT privilege issues where applications try to create databases as part of db:setup, as the user provided does not have permission to create or drop databases.

For Rails apps you should look to use db:schema:load, db:structure:load or db:migrate instead of db:setup.