Cannot connect to Postgresql DB hosted on heroku: "This schema does not exists [sic]."

Feature(s) impacted

Initial DB connection via NPM:

forest projects:create

Observed behavior

Creating your project on Forest Admin

Connecting to your database

× This schema does not exists.

Expected behavior

The default schema “public” is working (just like it does in pgadmin)


  • Project name:
  • Team name: Operations
  • Environment name: npm / postgres
  • Agent type & version: ?
  • Recent changes made on your end if any: none

Hi @hugo4711,

“public” is the default schema indeed.

What was the entire command you type to perform the project creation?

For example, I can reproduce the behavior you describe by putting a space " " instead of leaving blank the schema question.


I have solved the issue > we had created a special user for forest on heroku who had no permissions by default to the database schema.