pgroll

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.