pgroll
pgroll is an open-source command-line tool designed to simplify PostgreSQL schema migrations by enabling zero-downtime updates.
Our verdict
Who it's for
Perform zero-downtime, reversible schema migrations for PostgreSQL with ease.
Who should look elsewhere
Requires Go 1.24 or later for source installation
Pros
- +Eliminates downtime during database schema changes
- +Reduces risk with instant rollback functionality
- +Simplifies client application deployment by supporting multiple schema versions
- +Easy to integrate with existing PostgreSQL setups
- +Open-source and actively maintained
Cons
- −Requires Go 1.24 or later for source installation
- −Users need to manually configure client applications to use new schema versions
Key features
- ✓Zero-downtime migrations without database locking
- ✓Simultaneous operation of old and new schema versions
- ✓Automatic column backfilling
- ✓Instant rollback of migrations
- ✓Works with existing PostgreSQL schemas
- ✓Supports PostgreSQL 14.0 or later
- ✓Compatible with any PostgreSQL service (e.g., RDS, Aurora)
- ✓Cross-platform single binary written in Go
Pricing
| Plan | Price | Billing | Notes |
|---|---|---|---|
| Open Source | — | month | Full source code access; Apache License 2.0 license; Community support |