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.

agentskillexchange Updated 28 repo stars

File contents

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:

Basic usage or getting-started notes:

Source

agentskillexchange/skills/tree/main/skills/pgroll-postgresql-zero-downtime-schema-migration commit 297ea32d87

Frequently asked questions

npx skillmds@latest add agentskillexchange/pgroll-postgresql-zero-downtime-schema-migration