use alternate postgresql database for temporal

To use an alternate PostgreSQL database for Temporal in Airbyte, you need to modify the configuration in the

values.yaml

file if you are using Helm chart deployment or in the

.env

file if you are using Docker Compose. Here is an example of how you can configure it in the

values.yaml

file for Helm chart deployment:

yaml temporal:   extraEnv:     - name: DBNAME       value: 'your_temporal_db_name'     - name: VISIBILITY_DBNAME       value: 'your_temporal_visibility_db_name'     - name: SKIP_DB_CREATE       value: 'true'

And here is an example of how you can configure it in the

.env

file for Docker Compose:

shell DATABASE_USER=postgres DATABASE_PASSWORD=your_password DATABASE_HOST=your_postgres_host DATABASE_PORT=5432 DATABASE_DB=your_temporal_db_name DATABASE_URL=jdbc:<postgresql://your_postgres_host:5432/your_temporal_db_name?sslmode=require&ssl=true>

Please replace

your_temporal_db_name

,

your_temporal_visibility_db_name

,

your_password

, and

your_postgres_host

with your actual database name, visibility database name, password, and host respectively. Remember to manually create the

temporal

and

temporal_visibility

databases and make them available to the

postgres

user. Please note that these are just examples and you might need to adjust them according to your actual environment and requirements. Sources: - [Github Issue (closed): Error while setup schema on database temporal using external database > Original post Part 1](https://github.com/airbytehq/airbyte/issues/29552) - [[temporal] Unable to connect to external PostgreSQL database Part 1](https://github.com/airbytehq/airbyte/discussions/30482)