replication

Testing CloudNativePG Preferred Data Durability

Posted by Jeremy ⋅ October 5, 2025 ⋅ Leave a comment

This is the third post about running Jepsen against CloudNativePG. Earlier posts: First: shout out to whoever first came up with Oracle Data Guard Protection Modes. Designing it to be explained as a choice between performance, availability and protection was a great idea. Yesterday’s blog post described how the core of all data safety is copies of … Continue reading →

Losing Data is Harder Than I Expected

Posted by Jeremy ⋅ September 28, 2025 ⋅ 1 Comment

This is a follow‑up to the last article: Run Jepsen against CloudNativePG to see sync replication prevent data loss. In that post, we set up a Jepsen lab to make data loss visible when synchronous replication was disabled — and to show that enabling synchronous replication prevents it under crash‑induced failovers. Since then, I’ve been … Continue reading →

Run Jepsen against CloudNativePG to see sync replication prevent data loss

Posted by Jeremy ⋅ September 1, 2025 ⋅ 1 Comment

Are you in the Pacific Northwest? Want to learn more about topics related to this blog? At 3:15p on Thu Nov 13 in KubeCon Atlanta, I’ll be speaking with Leonardo Cecchi about distributed systems theory applied to standard open source postgres cluster reconfigurations. Jepsen is a testing framework for distributed systems that verifies safety guarantees … Continue reading →

PostgreSQL Logical Replicas and Snapshots: Proceed Carefully

Posted by Jeremy ⋅ July 26, 2021

Update 2024-Jan-24: this post has been linked from a few places after I wrote it in 2021. Just wanted to mention that there’s been ongoing discussion about logical replication and PostgreSQL. Instacart also has a newer blog post out about zero-downtime cutovers and it sounds like they’ve built some cool tooling. I think that two … Continue reading →

This Week in PostgreSQL – May 31

Posted by Jeremy ⋅ June 4, 2018

Since last October I’ve been periodically writing up summaries of interesting content I see on the internet related to PostgreSQL (generally blog posts). My original motivation was just to learn more about PostgreSQL – but I’ve started sharing them with a few colleagues and received positive feedback. Thought I’d try posting one of these digests … Continue reading →