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.
Features
- Database Schema Migrations - Provides a structured workflow for applying, completing, and reversing PostgreSQL schema migrations.
- Trigger-Based Backfills - Provides automated column backfill using batch updates and trigger-based synchronization during schema migrations.
- Trigger-Synced Column Backfills - Fills new columns from existing data and keeps them synchronized via triggers during migrations.
- Schema Version Views - Creates a stable view layer that abstracts schema changes for querying old or new versions by name.
- Simultaneous Schema Versions - Exposes old and new schema versions via views for gradual client transitions without interruption.
- View-Based Schema Versionings - Exposes each migration step as a pair of views presenting old and new schema versions simultaneously.
- Instant Migration Rollbacks - Reverses in-progress migrations instantly by removing the new schema version and restoring the previous one.
- Lock-Free Schema Evolutions - Implements non-blocking DDL operations that avoid exclusive locks on tables during schema changes.
- Zero-Downtime Migrations - Applies schema changes to a live PostgreSQL database without locking tables or breaking applications.
- PostgreSQL - Automates PostgreSQL schema changes without locking tables, keeping old and new versions accessible.
- Zero-Downtime Schema Migrations - Migrates PostgreSQL schemas without downtime, keeping old and new versions accessible.
- Instant Schema Rollbacks - Reverses in-progress migrations instantly by removing the new schema version and restoring the previous one.
- Online Schema Migration Tools - Applies schema changes without locking the database, keeping old and new versions accessible.
- Phased - Starts a migration to create a new schema version, then completes it after clients switch over.
- Trigger-Synced Backfills - Fills new columns from old ones and keeps them synchronized via triggers until migration completion.
- Transactional Migration Managers - Wraps each migration step in atomic database transactions for safe commit or rollback.
- Column - Installs database triggers that propagate changes bidirectionally to keep new columns synchronized during backfill.
- Schema and Migration Tools - Zero-downtime, reversible schema migration tool.
