pgroll PostgreSQL 无停机模式架构迁移
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:
- Usage
- ### Binaries
- Binaries are available for Linux, macOS & Windows, check our Releases.
- Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/xataio/pgroll/HEAD/README.md