Hi,
I am trying to setup schema and update schema to a specific schema, not using the public schema. Please help out on the process on doing so as I had gone through certain threads but couldn’t find a proper working example to setup the specifics using the temporal sql tool?
Tried out the following as well https://github.com/temporalio/temporal/issues/3383#issue-1373532593 - --ca flag seems to be missing.
SQL_DATABASE=temporal ./temporal-sql-tool --ca search_path=temporal setup-schema -v 0.0
SQL_DATABASE=temporal ./temporal-sql-tool update --ca search_path=temporal -schema-dir schema/postgresql/v96/temporal/versioned
SQL_DATABASE=temporal_visibility ./temporal-sql-tool --ca search_path=temporal setup-schema -v 0.0
SQL_DATABASE=temporal_visibility ./temporal-sql-tool update --ca search_path=temporal -schema-dir schema/postgresql/v96/visibility/versioned
Do we need to manually create the schema as well?