Add Support for Specifying Database Schema via Environment Variable

[somnath157]

I am trying to connect to an external database and have successfully done so by defining the PACT_BROKER_DATABASE_URL. However, the tables are being created under the public schema of the database. Since this database is used by multiple applications, I would like to have these tables under a specific schema for Pact Broker.

I couldn't find any way to achieve this using an environment variable. This seems like a common scenario and should ideally be controllable via an environment variable.

[mefellows]

The database URL can contain the schema you want to deploy it to, e.g.

postgres://user:pass@host:5432/dbname

Is this not what you need?

[mefellows]

Ah yes, schemas != databases.

[mefellows]

If the issue is logical separation, does multiple databases not solve the problem? I.e. the Pact Broker database should be separate to whatever else is on the postgres cluster. My understanding is that a schema is lower in the hierarchy than database. So it might be "public", but it's only public within the database itself.

[somnath157]

New DB will solve the problem of separation from application DB. But still there should be a way to define schema under that DB.

[YOU54F]

moved to pact_broker repo, as the pact-broker-docker repo serves to only have additional code for dockerisation

[maxforasteiro]

hey there!

since Postgres 15 public schema usage has changed and it is now recommended to not be used. it would be nice if this could be configured because of that.

[YOU54F]

Hey,

Do you have a link to the documentation where this is noted?

What would the implication be for existing PG users migrating to PG15 or later.

Would they be expected to migrate to a non public schema?

Cheers

[maxforasteiro]

This is the release note stating that global write has been removed from public schema: https://www.postgresql.org/docs/release/15.0/

This is the new recommendation for applications to start using separated schemas: https://wiki.postgresql.org/wiki/Database_Schema_Recommendations_for_an_Application