pgroll PostgreSQL Zero-Downtime Schema Migration
pgroll is an open-source CLI tool by Xata that performs zero-downtime, reversible schema migrations for PostgreSQL. It uses the expand-and-contract pattern to keep old and new schema versions running simultaneously with automatic backfilling and instant rollback.
Installation
Use the upstream install or setup path that matches your environment:
- go install github.com/xataio/pgroll@latest
- brew tap xataio/pgroll
- brew install pgroll
Requirements and caveats from upstream:
- Note: requires Go 1.24 or later.
Basic usage or getting-started notes:
Binaries
Binaries are available for Linux, macOS & Windows, check our Releases.
Source: https://github.com/xataio/pgroll
Extracted from upstream docs: https://raw.githubusercontent.com/xataio/pgroll/HEAD/README.md