New RunLLM response generated: >>>*# Question* Hi...
# runllm-flyte-trial
a
New RunLLM response generated: >>>*# Question* Hi all, we configure the postgresql database as follows:
Copy code
configuration:
            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.
Copy code
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.