pgroll
UnclaimedPerform zero-downtime, reversible schema migrations for PostgreSQL with ease.
Visit WebsiteFreeVisit Website
TL;DR - pgroll
- Enables zero-downtime PostgreSQL schema migrations.
- Supports simultaneous operation of old and new schema versions.
- Provides instant rollback capabilities for migrations.
Pricing: Free forever
Best for: Individuals & startups
Pros & Cons
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 lockingSimultaneous operation of old and new schema versionsAutomatic column backfillingInstant rollback of migrationsWorks with existing PostgreSQL schemasSupports PostgreSQL 14.0 or laterCompatible with any PostgreSQL service (e.g., RDS, Aurora)Cross-platform single binary written in Go
Pricing Plans
Open Source
Free
- Full source code access
- Apache License 2.0 license
- Community support
- Self-hosted
About pgroll
By Toolradar Team·
pgroll is an open-source command-line tool designed to simplify PostgreSQL schema migrations by enabling zero-downtime updates. It achieves this by serving multiple schema versions simultaneously, ensuring client applications continue to function without interruption even during complex or breaking changes. The tool handles the intricate aspects of migrations, such as applying changes without locking the database and automatically backfilling columns when necessary.
This tool is ideal for developers and organizations working with PostgreSQL databases who need to perform schema changes frequently without impacting application availability. It significantly reduces the risks associated with database migrations, allows for instant rollbacks in case of issues, and simplifies the client application rollout process. pgroll supports PostgreSQL 14.0 or later and works with various PostgreSQL services, including RDS and Aurora.
Reviews
No reviews yet. Be the first to review pgroll!
Explore More
pgroll FAQ
What is pgroll?
pgroll is an open-source command-line tool that facilitates safe and reversible zero-downtime schema migrations for PostgreSQL. It allows old and new schema versions to operate simultaneously, preventing database locking and enabling instant rollbacks.
How much does pgroll cost?
pgroll is an open-source tool released under the Apache-2.0 license, making it completely free to use.
Is pgroll free?
Yes, pgroll is free. It is an open-source project licensed under Apache-2.0.
Who is pgroll for?
pgroll is for developers, database administrators, and organizations that use PostgreSQL and need to perform schema changes without causing downtime or disrupting their applications. It's particularly useful for teams that require high availability and simplified migration processes.
Source: pgroll.com