Introducing pglifecycle 2.0 beta

From: "Gavin M(dot) Roy via PostgreSQL Announce" <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Introducing pglifecycle 2.0 beta
Date: 2026-10-14 10:48:56
Message-ID: 179197493612.2048042.4247161566941184008@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

I’m pleased to announce the first public release of [pglifecycle](https://github.com/gmr/pglifecycle), an open source schema management tool for PostgreSQL.

pglifecycle keeps your database schema in version control as structured YAML, with one file for each table, view, function, role, and other object. This makes the current schema easy to browse, review, and change without reconstructing it from years of migration files.

With pglifecycle, you can:

- Pull an existing database into a schema project
- Build that project into an archive for `pg_restore`
- Compare it with a live database and generate the DDL needed to reconcile them

Deployment is plan first. Destructive changes are withheld unless explicitly allowed, making the generated SQL suitable for review in CI.

The companion [pglifecycle GitHub Action](https://github.com/gmr/pglifecycle-action) can detect schema drift and post deployment plans directly to pull requests without applying them.

Version 2 is a Rust rewrite of the original tool, which has managed AWeber’s production schema for more than seven years. The beta release expands PostgreSQL object coverage and improves deployment convergence and safety.

* [Getting Started](https://pglifecycle.com/getting-started.html)
* [Documentation](https://pglifecycle.com/)
* [GitHub Action](https://github.com/gmr/pglifecycle-action)

Feedback and real world test cases are welcome as pglifecycle moves toward a stable 2.0 release.

Browse pgsql-announce by date

  From Date Subject
Next Message Postgresql ODBC via PostgreSQL Announce 2026-10-14 12:32:05 psqlODBC 18.00.0005 released with security fix for CVE-2026-109448
Previous Message PgBouncer via PostgreSQL Announce 2026-10-14 10:48:44 PgBouncer 1.26.1 released - Fixes three CVEs