PostgreSQL 14 RC 1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 14 is now available for download. As a release candidate, PostgreSQL 14 RC 1 will be mostly identical to the initial release of PostgreSQL 14, though some more fixes may be applied prior to the general availability of PostgreSQL 14.

The planned date for the general availability of PostgreSQL 14 is September 30, 2021. Please see the "Release Schedule" section for more details.

Upgrading to PostgreSQL 14 RC 1

To upgrade to PostgreSQL 14 RC 1 from earlier versions of PostgreSQL, you will need to use a major version upgrade strategy, e.g. pg_upgrade or pg_dump / pg_restore. For more information, please visit the documentation section on upgrading:

https://www.postgresql.org/docs/14/static/upgrading.html

Changes Since 14 Beta 3

Several bug fixes were applied for PostgreSQL 14 during the Beta 3 period. These include:

• The feature where autovacuum analyzes partitioned tables is reverted and will not be available in PostgreSQL 14.
• Fix EXPLAIN VERBOSE failing on a query with SEARCH BREADTH FIRST.
• CREATE STATISTICS now rejects single variable expressions.
• Fix issue where SELECT DISTINCT ROW would error.

For a detailed list of fixes, please visit the open items page.

Release Schedule

This is the first release candidate for PostgreSQL 14. Unless an issue is discovered that warrants a delay or to produce an additional release candidate, PostgreSQL 14 should be made generally available on September 30, 2021.

For further information please see the Beta Testing page.

Links

• Download
• Beta Testing Information
• PostgreSQL 14 RC 1 Release Notes
• PostgreSQL 14 Open Issues
• Submit a Bug
• Follow @postgresql on Twitter