PostgreSQL: PostgreSQL 19 Beta 2 Released!

July 16, 2026: PostgreSQL 19 Beta 2 Released!

Quick Links

About

Governance

Policies

Feature Matrix

Donate

History

Sponsors

Contributing

Financial

Servers

Latest News

Upcoming Events

Past events

Press

Licence

PostgreSQL 19 Beta 2 Released!

Posted on 2026-07-16 by PostgreSQL Global Development Group

PostgreSQL Project

The PostgreSQL Global Development Group announces that the second beta release of<br>PostgreSQL 19 is now available for download.<br>This release contains PostgreSQL 19 feature previews ahead of general<br>availability, though some details of the release can change during the beta<br>period.

You can find information about all of the PostgreSQL 19 features and changes in<br>the release notes:

https://www.postgresql.org/docs/19/release-19.html

In the spirit of the open source PostgreSQL community, we strongly encourage you<br>to test the new features of PostgreSQL 19 on your systems to help us eliminate<br>bugs and other issues. While we do not advise you to run beta versions in<br>production environments, we encourage you to find ways to run your typical<br>application workloads against this beta release.

Your testing and feedback help the community ensure that PostgreSQL 19<br>upholds our standards of delivering a stable, reliable release of the<br>world's most advanced open source relational database. Please read more about<br>our beta testing process and how<br>you can contribute:

https://www.postgresql.org/developer/beta/

Upgrading to PostgreSQL 19 Beta 2

To upgrade to PostgreSQL 19 Beta 2 from an earlier version of PostgreSQL,<br>you will need to use a strategy similar to upgrading between major versions of<br>PostgreSQL (e.g. pg_upgrade or pg_dump / pg_restore). For more<br>information, please visit the documentation section on<br>upgrading.

Changes Since Beta 1

Fixes and changes in PostgreSQL 19 Beta 2 include:

Fix a regression in vacuumdb --analyze-in-stages for partitioned tables.

Fix servicefile to show correct file after fallback to system file.

Fix tuple deformation optimization for virtual generated columns.

Allow pg_createsubscriber to accept duplicate publication names.

Fix REPACK worker not being cleaned up on a FATAL exit.

Several fixes for the new FOR PORTION OF temporal table syntax.

Fix race condition when logical decoding activation is concurrently<br>interrupted.

Disallow negative values for max_retention_duration.

Fix md5_password_warnings for role and database settings.

Several fixes for the new SQL/PGQ property graph feature.

Fix autovacuum's multixact-age score calculation, which could become infinite.

Revert non-text output formats for pg_dumpall.

Fix locking for ALTER DOMAIN ... VALIDATE CONSTRAINT.

Fix how postgres_fdw handles imported foreign-table statistics.

Please see the release notes<br>for a complete list of new and changed features:

https://www.postgresql.org/docs/19/release-19.html

Testing for Bugs & Compatibility

The stability of each PostgreSQL release greatly depends on you, the community,<br>to test the upcoming version with your workloads and testing tools to find bugs<br>and regressions before the general availability of PostgreSQL 19. As this is a<br>Beta, minor changes to database behaviors, feature details, and APIs are still<br>possible. Your feedback and testing will help determine the final tweaks on the<br>new features, so please test in the near future. The quality of user testing<br>helps determine when we can make a final release.

A list of open issues<br>is publicly available in the PostgreSQL wiki. You can<br>report bugs using this form on<br>the PostgreSQL website:

https://www.postgresql.org/account/submitbug/

Beta Schedule

This is the second beta release of version 19. The PostgreSQL Project will<br>release additional betas as required for testing, followed by one or more<br>release candidates, until the final release around September/October 2026. For further<br>information please see the Beta Testing<br>page.

Links

Download

Beta Testing Information

PostgreSQL 19 Beta Release Notes

PostgreSQL 19 Open Issues

Submit a Bug

Donate