# PostgreSQL HA: Commit Durability and Consistent Reads During Failover

**URL:** <https://forums.percona.com/t/postgresql-ha-commit-durability-and-consistent-reads-during-failover/41389>\
**Category:** PostgreSQL\
**Created:** [October 30, 2026, 2:38pm UTC](https://forums.percona.com/t/postgresql-ha-commit-durability-and-consistent-reads-during-failover/41389 "2026-10-30T14:38:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![NevTech](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nevtech/32/24437_2.png) [@NevTech](https://forums.percona.com/u/NevTech)\
**Post date:** [October 30, 2026, 2:38pm UTC](https://forums.percona.com/t/postgresql-ha-commit-durability-and-consistent-reads-during-failover/41389/1 "2026-10-30T14:38:42Z")

</div>

Hello PostgreSQL community,

I’m researching general PostgreSQL high-availability and transaction-durability behavior and would appreciate guidance on the following:

1. **Acknowledged commits:** Under which PostgreSQL replication and failover configurations can a successfully acknowledged transaction still be lost?

2. **Uncertain COMMIT outcomes:** If a database connection drops before the client receives a COMMIT acknowledgment, what is the recommended way to determine the transaction’s outcome safely?

3. **Consistency after failover:** What approaches prevent stale reads from replicas or newly promoted primary nodes when authoritative transaction state is required?

4. **Database unavailability:** What general application safeguards are recommended when security-sensitive operations must be denied because authoritative database state cannot be verified?

Are there particular PostgreSQL documentation references, Patroni configurations, or open-source testing tools you would recommend?

Thank you for your guidance.

---

<div class="post-metadata">

**Author:** ![hostersale](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hostersale/32/24448_2.png) [@hostersale](https://forums.percona.com/u/hostersale)\
**Post date:** [October 31, 2026, 6:27am UTC](https://forums.percona.com/t/postgresql-ha-commit-durability-and-consistent-reads-during-failover/41389/2 "2026-10-31T06:27:45Z")

</div>

This post was flagged by the community and is temporarily hidden.