db schema definition

[bitwise-io]

is it possible to define the db schema in the docker compose file for the db connection, because i don't want to use public as the default schema

my connection uri is:

• DATABASE_URL=postgresql://${DB_USERNAME:-planka}:${DB_PASSWORD}@${DB_HOSTNAME:-postgres}:${DB_PORT:-5432}/${DB_DATABASE:-planka}?options=-c%20search_path%3D${DB_SCHEMA:-planka}

.. with or without "?options..." it will not work, also when i've configured postgres to use another default schema for the user

i think planka is always looking for public schema because the logs tell me:

2026-05-11 15:03:57 [E] Sending 500 ("Server Error") response:
 Unexpected error from database adapter: relation "public.internal_config" does not exist

the docker run command with db:create-admin worked and the user exist in the db at the correct schema (not public), but not if i start docker compose up -d

hopefully someone could help

[sueun-dev]

this is the missing bit. I reproduced it with the current ghcr.io/plankanban/planka:latest image.

DATABASE_URL?...search_path=planka was enough for the Knex init path to create the tables under planka, but the Sails runtime still queried "public"."internal_config" and /api/bootstrap returned 500. Adding this to the Planka service env fixed the same setup for me:

sails_datastores__default__schemaName: planka

After that /api/bootstrap returned 200 and the tables stayed in the planka schema. So you need both pieces: the Postgres search_path for the Knex migration/init path, and the Sails datastore schemaName override for runtime queries.

[bitwise-io]

works well, thanks a lot 👌