Microsoft open sources pg_durable PostgreSQL extension

Microsoft has open‑sourced pg_durable, a PostgreSQL extension that provides a durable execution framework for database transactions. The project’s repository on GitHub details the implementation and includes installation instructions for PostgreSQL 13 and later [GitHub].

What shipped

pg_durable sits on top of PostgreSQL’s transaction engine and guarantees that each workflow step either completes fully or rolls back without leaving partial state. The extension adds a set of stored procedures and a scheduler that persist workflow state inside the database, enabling automatic retry after node failures. It is built for high availability and can scale across multiple nodes in a cluster.

Why it matters

• Reliability: By persisting workflow state in the same transaction log used by PostgreSQL, pg_durable eliminates the need for external state stores, reducing points of failure.
• Scalability: The extension leverages PostgreSQL’s native replication and sharding mechanisms, allowing large‑scale deployments to handle thousands of concurrent workflows.
• Community access: Publishing the code under an MIT license invites contributions, audits, and extensions from the broader open‑source community.

Developers can now embed complex orchestration logic directly in their databases, simplifying architecture and improving overall system resilience. The project’s roadmap lists upcoming features such as distributed transaction support and tighter integration with Azure services.