Single Postgres DB with multiple temporal and temporal_visibility schemas

Community Support
1

Hi Team,

The current automation creates database with name temporal and temporal_visibility, how to use the automation to create multiple schemas in single database like qa_temporal and qa_temporal_visibility in same database.

./temporal-sql-tool create-database -database temporal
./temporal-sql-tool create-database -database temporal_visibility

Thanks,
-Raj

2

exporting the SQA_DATABASE and updating the database name in temporalio/temporal/blob/release/v1.20.x/schema/postgresql/v12/temporal/database.sql#L1 worked.
export SQL_DATABASE=qa_temporal