So I have a prisma service up and running locally and am attempting to deploy it on heroku using the prisma add server wizard flow. I can complete the creation of a postgresql database and a server on heroku just fine. When viewing my list of servers in the prisma console, the new server shows with a status of healthy and version 1.23.0. when I click through to view the newly created server, the status is shown as ‘Not Reachable’.
When I go look into the heroku console and check the logs, I see this
2019-01-09T17:33:32.447436+00:00 app[web.1]: Jan 09, 2019 5:33:32 PM org.postgresql.Driver connect 2019-01-09T17:33:32.447458+00:00 app[web.1]: SEVERE: Connection error: 2019-01-09T17:33:32.447461+00:00 app[web.1]: org.postgresql.util.PSQLException: FATAL: permission denied for database "postgres" 2019-01-09T17:33:32.447463+00:00 app[web.1]: Detail: User does not have CONNECT privilege.
Has anyone seen this, or can point me in the right direction to start getting this fixed?