Due to limits in the production environment of our website, we can not use Postgres' standard schema
Therefore we configured something different (
craftcms) in .env:
DB_DRIVER=pgsql DB_SERVER=<hostname> DB_PORT=5432 DB_DATABASE=<database> DB_USER=<user> DB_PASSWORD=<pw> DB_SCHEMA=craftcms DB_TABLE_PREFIX=
Interestingly this works in our production environment, but not locally when developing with Nitro.
Only difference: the
username of the DB connection is
craftcms on production, but locally it's
Why is that?