xataio/pgroll
Pgroll
pgroll is a PostgreSQL migration framework designed for zero-downtime schema changes. It applies non-blocking DDL operations that avoid exclusive locks on tables, and uses trigger-based column backfill to populate new columns while keeping them synchronized with old ones. The framework wraps each migration step in a database transaction that can be atomically committed or rolled back, and creates a versioned view layer that exposes both old and new schema versions simultaneously to client applications.
The tool distinguishes itself by managing multiple schema versions via views, enabling safe rollbacks and phased rollouts. It supports a step-by-step online migration workflow that creates new schema versions, backfills columns with trigger-based sync, and serves multiple versions so client applications can transition gradually without interruption. In-progress migrations can be reversed instantly by removing the new schema version and restoring the previous one.
The project covers automated column backfill, multi-version schema serving, and rollback migration management for PostgreSQL databases. Its documentation provides guidance on running migrations step by step, rolling back changes, and serving multiple schema versions simultaneously.
