# \#database **URL:** https://community.temporal.io/tag/database/52.md [Latest](https://community.temporal.io/latest.md) · [Categories](https://community.temporal.io/categories.md) · [Tags](https://community.temporal.io/tags.md) --- ## [Cross-region MySQL Deployment - context deadline exceeded errors in history pod](https://community.temporal.io/t/cross-region-mysql-deployment-context-deadline-exceeded-errors-in-history-pod/18693)
**Author:** [@lss](https://community.temporal.io/u/lss)\ **Replies:** 2\ **Last updated:** [March 1, 2026, 2:14am UTC](https://community.temporal.io/t/cross-region-mysql-deployment-context-deadline-exceeded-errors-in-history-pod/18693 "2026-03-01T02:14:53Z")
Hi temporal team, We are experiencing persistent “context deadline exceeded” errors in our Temporal deployment, specifically in the temporal-history pod. Here’s our setup: Temporal v 1.21.3 on Kubernetes cluster in In… --- ## [Temporal History retention period](https://community.temporal.io/t/temporal-history-retention-period/4348)
**Author:** [@Huong\_Pham](https://community.temporal.io/u/Huong_Pham)\ **Replies:** 3\ **Last updated:** [November 29, 2025, 11:17am UTC](https://community.temporal.io/t/temporal-history-retention-period/4348 "2025-11-29T11:17:12Z")
Hi, From this article I learn that Temporal stores data that is generated from a Workflow, such as Event Histories, per the configured retention period. When the retention period expires the data is deleted to avoid … --- ## [AWS RDS(PostgreSQL) + IAM Authentication](https://community.temporal.io/t/aws-rds-postgresql-iam-authentication/3168)
**Author:** [@forzaken](https://community.temporal.io/u/forzaken)\ **Replies:** 10\ **Last updated:** [November 26, 2025, 5:40pm UTC](https://community.temporal.io/t/aws-rds-postgresql-iam-authentication/3168 "2025-11-26T17:40:55Z")
Hi folks, we are planning to use temporal with postgreSQL in AWS RDS, however we would like to know if it will be possible for temporal to use IAM authentication rather than regular (user+password) by implementing some s… --- ## [What's the latest supported version of postgres that is supported?](https://community.temporal.io/t/whats-the-latest-supported-version-of-postgres-that-is-supported/18265)
**Author:** [@jdnewman](https://community.temporal.io/u/jdnewman)\ **Replies:** 0\ **Last updated:** [August 25, 2025, 6:03pm UTC](https://community.temporal.io/t/whats-the-latest-supported-version-of-postgres-that-is-supported/18265 "2025-08-25T18:03:47Z")
Apologies if this is documented somewhere I’m missing. I suppose the question could be broken into a few: What’s the latest supported/recommended postgres version? What’s the latest should work postgres version, if di… --- ## [Workflow gets stuck in random activities](https://community.temporal.io/t/workflow-gets-stuck-in-random-activities/18198)
**Author:** [@arturobac](https://community.temporal.io/u/arturobac)\ **Replies:** 5\ **Last updated:** [August 18, 2025, 4:37pm UTC](https://community.temporal.io/t/workflow-gets-stuck-in-random-activities/18198 "2025-08-18T16:37:17Z")
Hi Team, I have the following setup: k8s, Temporal Helm Chart 0.65.0, PostgreSQL-HA Bitnami Helm Chart 16.0.22, some other containers (activity workers) - with one replica to make testing easier: core-79566f69bf-d8smx … --- ## [Allow Temporal and Visibility Schemas in a Single Database by Renaming schema\_version Table](https://community.temporal.io/t/allow-temporal-and-visibility-schemas-in-a-single-database-by-renaming-schema-version-table/17151)
**Author:** [@Dorijan](https://community.temporal.io/u/Dorijan)\ **Replies:** 1\ **Last updated:** [April 20, 2025, 1:13pm UTC](https://community.temporal.io/t/allow-temporal-and-visibility-schemas-in-a-single-database-by-renaming-schema-version-table/17151 "2025-04-20T13:13:50Z")
Currently, Temporal and Temporal Visibility schemas can’t coexist in one database because both use the same schema\_version table, causing version conflicts and blocking seamless upgrades. Would it be possible renaming t… --- ## [AlloyDB integration with Temporal](https://community.temporal.io/t/alloydb-integration-with-temporal/16977)
**Author:** [@ajale-panw](https://community.temporal.io/u/ajale-panw)\ **Replies:** 1\ **Last updated:** [March 31, 2025, 1:04am UTC](https://community.temporal.io/t/alloydb-integration-with-temporal/16977 "2025-03-31T01:04:25Z")
We are facing issues when trying to attach an AlloyDB auth proxy sidecar to Temporal. Temporal is working when connected to a standard postgres db and the AlloyDB sidecar is working when attached to other pods, but Tempo… --- ## [Database spike because of retention deletion process](https://community.temporal.io/t/database-spike-because-of-retention-deletion-process/16558)
**Author:** [@ehsan.qlub](https://community.temporal.io/u/ehsan.qlub)\ **Replies:** 3\ **Last updated:** [February 24, 2025, 3:32pm UTC](https://community.temporal.io/t/database-spike-because-of-retention-deletion-process/16558 "2025-02-24T15:32:43Z")
Hi, We are running Temporal in our production environment, but we occasionally experience significant CPU spikes in our PostgreSQL database (specifically, temporal\_visibility). Given the high number of DELETE queries, w… --- ## [What is recommended approach on starting workflow in transaction?](https://community.temporal.io/t/what-is-recommended-approach-on-starting-workflow-in-transaction/16248)
**Author:** [@alexey.nikitenko](https://community.temporal.io/u/alexey.nikitenko)\ **Replies:** 4\ **Last updated:** [February 13, 2025, 2:21am UTC](https://community.temporal.io/t/what-is-recommended-approach-on-starting-workflow-in-transaction/16248 "2025-02-13T02:21:44Z")
We use a self-hosted Temporal server and Python SDK. For some business processes, we have to start a workflow in transactions to ensure data consistency. For example: start a transaction write in DB; write in DB again… --- ## [Best approach for compering data across multiple Temporal Workflows](https://community.temporal.io/t/best-approach-for-compering-data-across-multiple-temporal-workflows/16155)
**Author:** [@Dandy](https://community.temporal.io/u/Dandy)\ **Replies:** 1\ **Last updated:** [January 22, 2025, 2:38am UTC](https://community.temporal.io/t/best-approach-for-compering-data-across-multiple-temporal-workflows/16155 "2025-01-22T02:38:07Z")
Hi, We have long-running workflows in our system and are exploring the best way to compare data across multiple workflows for product-related purposes. Would you recommend querying Temporal directly for this comparison… --- ## [How to mannually clean up activity\_info\_map table](https://community.temporal.io/t/how-to-mannually-clean-up-activity-info-map-table/14765)
**Author:** [@Sczlog](https://community.temporal.io/u/Sczlog)\ **Replies:** 7\ **Last updated:** [November 13, 2024, 6:59am UTC](https://community.temporal.io/t/how-to-mannually-clean-up-activity-info-map-table/14765 "2024-11-13T06:59:00Z")
I am using temporal to run scheduler for syncing data from outside datasource, it works good for serveral month until hours ago, I found service was unavailable, and postgresql container was down. Check the message of p… --- ## [Activity Retry Temporal Database consumption](https://community.temporal.io/t/activity-retry-temporal-database-consumption/13166)
**Author:** [@MichaelKruglov](https://community.temporal.io/u/MichaelKruglov)\ **Replies:** 3\ **Last updated:** [August 15, 2024, 5:36pm UTC](https://community.temporal.io/t/activity-retry-temporal-database-consumption/13166 "2024-08-15T17:36:22Z")
In our project we use workflows with multiple activity retries and long WF timeout (syncronisaion process with another services). So I want to understand how my Temporal Database memory will be consumed. Is a new table… --- ## [Impact on using single RDS for both Application DB and Temporal DB](https://community.temporal.io/t/impact-on-using-single-rds-for-both-application-db-and-temporal-db/12799)
**Author:** [@Nirmal\_Balaji\_Packir](https://community.temporal.io/u/Nirmal_Balaji_Packir)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:52am UTC](https://community.temporal.io/t/impact-on-using-single-rds-for-both-application-db-and-temporal-db/12799 "2024-07-12T05:52:49Z")
We have a AWS RDS instance, that holds a DB with customer data in used by our custom application. If we were to use the same RDS to host temporal and temporal\_visibility DBs, what will be the impact on CPU/memory/storage… --- ## [Temporal stopped working after DB (AWS RDS postgresql) auto minor version upgrade](https://community.temporal.io/t/temporal-stopped-working-after-db-aws-rds-postgresql-auto-minor-version-upgrade/12786)
**Author:** [@Amanjeet](https://community.temporal.io/u/Amanjeet)\ **Replies:** 0\ **Last updated:** [July 11, 2024, 1:54am UTC](https://community.temporal.io/t/temporal-stopped-working-after-db-aws-rds-postgresql-auto-minor-version-upgrade/12786 "2024-07-11T01:54:11Z")
We currently use AWS RDS (postgresql) as the database behind temporal, and have not had any issues for the last couple years with this. Last week, a minor version upgrade of the DB was performed automatically by AWS, and… --- ## [Namespaces data isolation in the database](https://community.temporal.io/t/namespaces-data-isolation-in-the-database/12753)
**Author:** [@Dandy](https://community.temporal.io/u/Dandy)\ **Replies:** 1\ **Last updated:** [July 7, 2024, 6:27pm UTC](https://community.temporal.io/t/namespaces-data-isolation-in-the-database/12753 "2024-07-07T18:27:34Z")
Hi, We’re working on implementing multi-tenancy and decided that namespaces would work best for our use case. However, we have concerns regarding how data is stored. Our potential partners are very concerned about the i… --- ## [Temporal connectivity with local cockroachdb (single-node)](https://community.temporal.io/t/temporal-connectivity-with-local-cockroachdb-single-node/12664)
**Author:** [@midun](https://community.temporal.io/u/midun)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 9:10am UTC](https://community.temporal.io/t/temporal-connectivity-with-local-cockroachdb-single-node/12664 "2024-06-27T09:10:41Z")
Hi temporal community, I am very new to this temporal space. Just now I am trying to getting started to understand things in Temporal. Now I want to use some persistent store to work with temporal. I am running my cockr… --- ## [Cassandra query time-out when deleting workflow executions from deleted namespace](https://community.temporal.io/t/cassandra-query-time-out-when-deleting-workflow-executions-from-deleted-namespace/11265)
**Author:** [@l\_benke\_futureplc](https://community.temporal.io/u/l_benke_futureplc)\ **Replies:** 0\ **Last updated:** [March 6, 2024, 2:38pm UTC](https://community.temporal.io/t/cassandra-query-time-out-when-deleting-workflow-executions-from-deleted-namespace/11265 "2024-03-06T14:38:38Z")
Hi, i’ve deleted a namespace from our self-hosted cluster using temporal CLI. The namespace contained a lot of open executions for which no workers were listening. After deleting the namespace, a new namespace marked a… --- ## [Error while running Temporal on TiDB](https://community.temporal.io/t/error-while-running-temporal-on-tidb/4159)
**Author:** [@arjunraman](https://community.temporal.io/u/arjunraman)\ **Replies:** 5\ **Last updated:** [September 19, 2023, 8:29am UTC](https://community.temporal.io/t/error-while-running-temporal-on-tidb/4159 "2023-09-19T08:29:36Z")
Hello, I’m trying to test Temporal on TiDB and see the below error message in the history server when trying to start an execution: {“level”:“error”,“ts”:“2022-03-10T23:35:44.820Z”,“msg”:“Operation failed with interna… --- ## [Atomic transactions in MongoDb managed from activity](https://community.temporal.io/t/atomic-transactions-in-mongodb-managed-from-activity/8922)
**Author:** [@MarekKuticka](https://community.temporal.io/u/MarekKuticka)\ **Replies:** 0\ **Last updated:** [July 21, 2023, 7:20pm UTC](https://community.temporal.io/t/atomic-transactions-in-mongodb-managed-from-activity/8922 "2023-07-21T19:20:02Z")
Hi everyone. I have recently discovered Temporal, and while learning Go, its a wonderful tool. I’d like to open a discussion regarding using Temporal to manage data import process. to be honest, I still do not know the… --- ## [Persisting a MongoDB connection](https://community.temporal.io/t/persisting-a-mongodb-connection/8369)
**Author:** [@nathan\_hyland](https://community.temporal.io/u/nathan_hyland)\ **Replies:** 1\ **Last updated:** [May 27, 2023, 3:05pm UTC](https://community.temporal.io/t/persisting-a-mongodb-connection/8369 "2023-05-27T15:05:29Z")
I’ve got a workflow where a few of the activities need to reach out to MongoDB and modify collections. We’ve got applications on lambda and we needed to make sure we initialized the connection outside the handler to make… --- ## [Does Temporal only support Postgres v9.6?](https://community.temporal.io/t/does-temporal-only-support-postgres-v9-6/1755)
**Author:** [@joeyd](https://community.temporal.io/u/joeyd)\ **Replies:** 3\ **Last updated:** [April 10, 2023, 8:34pm UTC](https://community.temporal.io/t/does-temporal-only-support-postgres-v9-6/1755 "2023-04-10T20:34:41Z")
Hi all, The web site specs state Postgres v9.6 is supported and doesn’t indicate newer editions are included. Should I be sticking with v9.6 or does anyone know / have later versions in production? Many thanks, Joe --- ## [Occasional "Consistent query buffer is full"](https://community.temporal.io/t/occasional-consistent-query-buffer-is-full/2987)
**Author:** [@mrsaints](https://community.temporal.io/u/mrsaints)\ **Replies:** 18\ **Last updated:** [February 21, 2023, 6:30pm UTC](https://community.temporal.io/t/occasional-consistent-query-buffer-is-full/2987 "2023-02-21T18:30:54Z")
We’ve been seeing quite a few “consistent query buffer is full, cannot accept new consistent queries” coming from the history service. I noticed there is a similar topic (Often seeing "consistent query buffer is full, ca… --- ## [Why restriction on retention period 30 days?](https://community.temporal.io/t/why-restriction-on-retention-period-30-days/5009)
**Author:** [@Pradeep](https://community.temporal.io/u/Pradeep)\ **Replies:** 6\ **Last updated:** [December 2, 2022, 4:05pm UTC](https://community.temporal.io/t/why-restriction-on-retention-period-30-days/5009 "2022-12-02T16:05:57Z")
I understand the reason behind the retention and archiving of completed workflows but can’t we have retention period config time based on the user needs? If the temporal runs on the scalable data source like Cassandra, d… --- ## [Passing sensitive data from workflow to activity](https://community.temporal.io/t/passing-sensitive-data-from-workflow-to-activity/505)
**Author:** [@Gordon\_Bean](https://community.temporal.io/u/Gordon_Bean)\ **Replies:** 1\ **Last updated:** [August 21, 2020, 6:25pm UTC](https://community.temporal.io/t/passing-sensitive-data-from-workflow-to-activity/505 "2020-08-21T18:25:02Z")
In our application, a workflow begins with a user JWT, which is used to orchestrate activities on behalf of the user across micro-services. Calls to the individual micro-services will be in activities, requiring that th… --- ## [Check workflow execution history in database](https://community.temporal.io/t/check-workflow-execution-history-in-database/6489)
**Author:** [@nehapatil7199](https://community.temporal.io/u/nehapatil7199)\ **Replies:** 6\ **Last updated:** [November 16, 2022, 2:14am UTC](https://community.temporal.io/t/check-workflow-execution-history-in-database/6489 "2022-11-16T02:14:17Z")
Hi, I am using python and Nodejs SDKs for activities & workflow respectively and using PostgreSQL for database. I want to check workflow execution history in database. Checked history\_node & history\_tree table in datab… --- ## [Possible to support ScyllaDB?](https://community.temporal.io/t/possible-to-support-scylladb/532)
**Author:** [@H.Drake](https://community.temporal.io/u/H.Drake)\ **Replies:** 5\ **Last updated:** [October 25, 2022, 9:06pm UTC](https://community.temporal.io/t/possible-to-support-scylladb/532 "2022-10-25T21:06:57Z")
Hi, Got 2 qn, Is it possible to provide support for scylladb? its similar to cassandra. as scylladb also support cql, is it possible for temporal to allow lower cql version? (currently temporal using cql version 3.4.4… --- ## [How to provide DB credentials to Temporal from a file](https://community.temporal.io/t/how-to-provide-db-credentials-to-temporal-from-a-file/6018)
**Author:** [@joebowbeer](https://community.temporal.io/u/joebowbeer)\ **Replies:** 2\ **Last updated:** [September 20, 2022, 5:47am UTC](https://community.temporal.io/t/how-to-provide-db-credentials-to-temporal-from-a-file/6018 "2022-09-20T05:47:53Z")
The existingSecret means of providing a database password is implemented to inject the password as an environment variable using valueFrom / secretKeyRef. However, CIS Benchmark generally recommends not passing secrets … --- ## [How to provide DB credentials to temporal in production?](https://community.temporal.io/t/how-to-provide-db-credentials-to-temporal-in-production/4655)
**Author:** [@Ruchir](https://community.temporal.io/u/Ruchir)\ **Replies:** 2\ **Last updated:** [September 19, 2022, 8:05pm UTC](https://community.temporal.io/t/how-to-provide-db-credentials-to-temporal-in-production/4655 "2022-09-19T20:05:38Z")
Hi Experts, Currently, for Temporal helm charts, for connecting to a postgresql DB, following is the sample provided: server: config: persistence: default: driver: "sql" sql: driv… --- ## [Is it possible to sharding the database when there are too many task results?](https://community.temporal.io/t/is-it-possible-to-sharding-the-database-when-there-are-too-many-task-results/5893)
**Author:** [@yongye](https://community.temporal.io/u/yongye)\ **Replies:** 7\ **Last updated:** [September 6, 2022, 5:03pm UTC](https://community.temporal.io/t/is-it-possible-to-sharding-the-database-when-there-are-too-many-task-results/5893 "2022-09-06T17:03:04Z")
I’m new here. In a certain field of business, the data in a single table has exceeded 5 million, and a timeout occurs when filtering data for a certain query condition. Is it possible to sharding the database when there … --- ## [Pattern for ensuring consistency between DB save and Workflow](https://community.temporal.io/t/pattern-for-ensuring-consistency-between-db-save-and-workflow/3504)
**Author:** [@venkyvb](https://community.temporal.io/u/venkyvb)\ **Replies:** 11\ **Last updated:** [September 1, 2022, 9:43am UTC](https://community.temporal.io/t/pattern-for-ensuring-consistency-between-db-save-and-workflow/3504 "2022-09-01T09:43:13Z")
We have a use-case where a micro-service (e.g. order management) should first persist the order in its own data base and trigger a fulfillment workflow (using Temporal). We want to make sure that overall the process is t… [Next page](https://community.temporal.io/tag/database/52.md?match_all_tags=true&page=1&tags%5B%5D=database)