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

Help me!
1

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)

Context

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

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.

Regards

3

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.