This blog takes you on a guided tour of PostgreSQL’s internal process world from startup to shutdown explaining how these processes work together to keep your database safe, fast, and...
I love the annual StackOverFlow Developer Survey. The survey contains simple questions with direct, simple answers. I’s also about something that I love following and keeping up with: the software...
Oracle and PostgreSQL are both popular database management systems, but how each one functions is vastly different. In today’s digital age, your organization needs to choose a system that aligns...
If Postgres crashes you can get a stack trace with gdb. But how do you debug errors that don't crash Postgres? Let's grab the Postgres 17 source and build it...
Users of EDB Postgres Distributed (PGD) typically use a write-leader for a cluster, which is a node elected by Raft to do writes to the database. Even when a write-leader...
PostgreSQL offers powerful physical and logical replication mechanisms for ensuring data availability. EDB's Postgres Distributed (PGD) builds on these by providing an advanced, flexible distributed database solution, offering active-active replication...
A Testament to Craft, Community, and the Future of Open Source At EDB, we believe the best way to predict the future of Postgres is to build it. We are...
In this post we'll set up a 3-node EDB Postgres Distributed (PGD) cluster running community Postgres 16. Then we'll upgrade the entire cluster in place from Postgres 16 to Postgres...
From time to time we see queries about best practice for PostgreSQL backups. I saw one just the other day. The first thing to note is that a backup strategy...
