ancient-wolf-19325
07/24/2024, 12:01 PMconfiguration:
database:
username: postgres
host: postgres.flyte.svc.cluster.local
dbname: flyteadmin
Is it also possible to configure the schema? Currently the schema "public" is used (the default schema of postgreSQL). Since we are sharing the database with other applications it would be good to have the flyte-related tables in a separate schema - is this possible?
Thanks!
# Answer
Flyte does not explicitly mention schema configuration in the provided data sources. The configuration options for the PostgreSQL database in Flyte are limited to specifying the username, host, and database name, as seen in the postgres_config.yaml and values.yaml files.
database:
postgres:
port: 5432
username: postgres
host: postgres
dbname: postgres
options: "sslmode=disable"
To use a different schema, you might need to manually configure the schema in PostgreSQL and ensure Flyte uses it by setting the search_path in the options parameter. However, this is not explicitly documented in the provided sources.
Would you like more details on how to potentially configure this manually?
Sources:
- postgres_config.yaml
- values.yaml
Slack Link
https://flyte-org.slack.com/archives/CP2HDHKE1/p1721822477.748369 👍 0 button 👎 0 button 💡 Hint: Mention @runllm in the thread for followups.