PostgreSQL 15

PostgreSQL 15 is the future development version of PostgreSQL, likely to be released in late 2022.

Initial commit marking the start of PostgreSQL 15 development is 596b5af1 (2021-06-28).

CommitFests

Following CommitFests are for PostgreSQL 15 code submissions:

Backend changes

General

postmaster

  • option --forkboot renamed to --forkaux (commit 50017f77)
  • CREATE privilege on the public schema is now always revoked by default from PUBLIC, and it is now owned by pg_database_owner role (commit b073c3cc)

Data type changes

  • NUMERIC scale can be negative or greater than precision (commit 085f931f)

SQL changes

Modified:

System catalog changes

Modified:

System function changes

Modified:

Configuration changes

Added:

Replication changes

Logical replication

  • support for prepared transactions added (commit a8fd13ca)
  • support for for streaming transactions added (commit 63cf61cd)

Replication protocol

  • TWO_PHASE option added to CREATE_REPLICATION_SLOT (commit cda03cfe)

System functions

Added:

Modified:

Core utilities

Server utilities

psql

  • new environment variable PSQL_WATCH_PAGER for setting a pager for psql's \watch command (commit 7c09d279)

Contrib modules