| 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.
| 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 |