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

Resolution

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.