DATABASES Signal 205
PostgreSQL 19 Beta 2 Released!
↗
Engineers can begin testing upcoming features like temporal tables, property graph support, and virtual generated columns against real workloads. Several fixes in Beta 2 address notable regressions from Beta 1, including an autovacuum multixact-age calculation that could become infinite, making this a more viable target for early compatibility testing.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
Upgrading to PostgreSQL 19 Beta 2 requires a major-version strategy such as pg_upgrade or pg_dump and pg_restore.
Beta 2 resolves bugs across several new features, including FOR PORTION OF temporal syntax, SQL/PGQ property graph support, and virtual generated columns.
The project plans additional beta releases followed by release candidates, with a final release targeted around September or October 2026.
THE CLUSTER