Using other Postgres schema than "public"

[axelrindle]

Hello,

I want to run Outline v0.75.2 with a Postgres database, but cannot use any other schema than public. Has somebody achieved this?

My connection url is:

DATABASE_URL=postgres://outline:outline@db:5432/mydb?searchpath=outline&currentSchema=outline

Error:

yarn run v1.22.19
$ node ./build/server/index.js
{"label":"lifecycle","level":"info","message":"Note: Restricting process count to 1 due to use of collaborative service"}
(node:28) NOTE: We are formalizing our plans to enter AWS SDK for JavaScript (v2) into maintenance mode in 2023.

Please migrate your code to use AWS SDK for JavaScript (v3).
For more information, check the migration guide at https://a.co/7PzMCcy
(Use `node --trace-warnings ...` to show where the warning was created)
{"label":"lifecycle","level":"info","message":"\nIs your team enjoying Outline? Consider supporting future development by sponsoring the project:\n\nhttps://github.com/sponsors/outline\n"}
{"label":"database","level":"info","message":"Running migrations…"}
{"label":"database","level":"info","message":"Migrating 20160622043741-add-parent-document.js…"}
{"level":"warn","message":"Migration 20160622043741-add-parent-document.js (up) failed: Original error: schema \"public\" does not exist"}
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

[tommoor]

There's no support for this currently, if you wanted to add it that might be an acceptable PR – I'd imagine the surface area is quote small

[axelrindle]

I opened a PR: #6670