The PostgreSQL Global Development Group announces that the second beta release of
PostgreSQL 15 is now [available for download](https://www.postgresql.org/download/).
This release contains previews of all features that will be available when
PostgreSQL 15 is made generally available, though some details of the release
can change during the beta period.

You can find information about all of the features and changes found in
PostgreSQL 15 in the [release notes](https://www.postgresql.org/docs/15/release-15.html):

  [https://www.postgresql.org/docs/15/release-15.html](https://www.postgresql.org/docs/15/release-15.html)

In the spirit of the open source PostgreSQL community, we strongly encourage you
to test the new features of PostgreSQL 15 on your systems to help us eliminate
bugs or other issues that may exist. While we do not advise you to run
PostgreSQL 15 Beta 1 in production environments, we encourage you to find ways
to run your typical application workloads against this beta release.

Your testing and feedback will help the community ensure that the PostgreSQL 15
release upholds our standards of delivering a stable, reliable release of the
world's most advanced open source relational database. Please read more about
our [beta testing process](https://www.postgresql.org/developer/beta/) and how
you can contribute:

  [https://www.postgresql.org/developer/beta/](https://www.postgresql.org/developer/beta/)

Upgrading to PostgreSQL 15 Beta 2
---------------------------------

To upgrade to PostgreSQL 15 Beta 2 from an earlier version of PostgreSQL,
you will need to use a strategy similar to upgrading between major versions of
PostgreSQL (e.g. `pg_upgrade` or `pg_dump` / `pg_restore`). For more
information, please visit the documentation section on
[upgrading](https://www.postgresql.org/docs/15/static/upgrading.html).

Changes Since Beta 1
--------------------

There have been many bug fixes for PostgreSQL 15 reported during the Beta 1
period and applied to the Beta 2 release. This includes:

* `JSON_TABLE` output columns now use the collations of their data type.
* `pg_publication_tables` now provides information on column lists and row filters.
* Prohibit combining publications with different column lists.
* `string` is now an unreserved keyword.
* Several fixes for the output of `EXPLAIN MERGE`.
* Multiples fixes for `COPY .. WITH (HEADER MATCH)`.
* Revert ignoring HOT updates for BRIN indexes.
* Internal fix for amcheck.
* Fix for `psql` to show `NOTICE` statements immediately, not at the end of a
transaction.
* Fix `\timing` in `psql` so that it will still return a time even if there is
an error.
* The `\dconfig` command in `psql` reduces the number of default settings
displayed when used without any arguments.
* Fix for `pg_upgrade` to improve its idempotence.
* Fix check in `pg_upgrade` for ICU collations.
* Allow `--partitions=0` to work with `pgbench`.

Please see the [release notes](https://www.postgresql.org/docs/15/release-15.html)
for a complete list of new and changed features:

  [https://www.postgresql.org/docs/15/release-15.html](https://www.postgresql.org/docs/15/release-15.html)

Testing for Bugs & Compatibility
--------------------------------

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

A list of [open issues](https://wiki.postgresql.org/wiki/PostgreSQL_15_Open_Items)
is publicly available in the PostgreSQL wiki.  You can
[report bugs](https://www.postgresql.org/account/submitbug/) using this form on
the PostgreSQL website:

  [https://www.postgresql.org/account/submitbug/](https://www.postgresql.org/account/submitbug/)

Beta Schedule
-------------

This is the second beta release of version 15. The PostgreSQL Project will
release additional betas as required for testing, followed by one or more
release candidates, until the final release in late 2022. For further
information please see the [Beta Testing](https://www.postgresql.org/developer/beta/) page.

Links
-----

* [Download](https://www.postgresql.org/download/)
* [Beta Testing Information](https://www.postgresql.org/developer/beta/)
* [PostgreSQL 15 Beta Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [PostgreSQL 15 Open Issues](https://wiki.postgresql.org/wiki/PostgreSQL_15_Open_Items)
* [Submit a Bug](https://www.postgresql.org/account/submitbug/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)