PostgreSQL versions/releases

PostgreSQL: https://en.wikipedia.org/wiki/PostgreSQL#Release_history

Releases (yearly)

PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history

• Sep 2023 PostgreSQL 16.0 annoucement Release notes
  • Introduces logical replication
  • pg_stat_io view for I/O metrics https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-IO-VIEW
  • Amazon RDS for PostgreSQL now supports major version 16

• Oct 2022 PostgreSQL 15.0: (15.7)announcement Release notes
  • Improved Sort Performance and Compression
  • Included SQL standard MERGE command
  • Additional logical replication options
  • jsonlog logging
  • pg_walinspect
  • Revokes the CREATE permission from all users except a database owner from the public (or default) schema

• Oct 2021 PostgreSQL 14.0: Release notes
  • Azure
  • GRANT pg_read_all_data TO xxx;

• Oct 2020 PostgreSQL 13.0: Release notes
  • Space savings and performance gains from de-duplication of B-tree index entries
  • Improved performance for queries that use aggregates or partitioned tables
  • Better query planning when using extended statistics
  • Parallelized vacuuming of indexes
  • Incremental sorting
  • Added FORCE option to DROP DATABASE
  • Added LOCALE option to CREATE DATABASE
  • --quiet to pg_waldump
  • --include-foreign-data to pg_dump

• October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/
  • Ubuntu 20.04 LTS
• October 2018 PostgreSQL 11.0 https://www.postgresql.org/about/news/1894/, https://www.postgresql.org/docs/release/11.0/
• October 2017 PostgreSQL 10.0 https://www.postgresql.org/docs/release/10.0/ (Ubuntu 18.04 LTS (BionicBeaver))
• October 2010 PostgreSQL 9.0 https://www.postgresql.org/docs/release/9.0/
  • November 2010 PostgreSQL 9.1 https://www.postgresql.org/docs/release/9.1/
  • December 2010 PostgreSQL 9.2 https://www.postgresql.org/docs/release/9.2/
    • January 2011 PostgreSQL 9.3 https://www.postgresql.org/docs/release/9.3/
    • April 2011 PostgreSQL 9.4 https://www.postgresql.org/docs/release/9.4/
    • 2016-01-07 PostgreSQL 9.5 https://www.postgresql.org/docs/release/9.5/
    • 2016-09-29 PostgreSQL 9.6 https://www.postgresql.org/docs/release/9.6/

Related

• pg_upgradecluster
• MariaDB changelog
• AWS RDS for PostgreSQL release notes
• /etc/postgresql/
• brew install postgresql, brew install postgresql@16
• Amazon Aurora
• Using Amazon RDS Blue/Green Deployments for database updates
• engine version (Terraform resource: aws db instance)

See also

• PostgreSQL versions/releases, /etc/postgresql/

https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS

https://www.postgresql.org/about/news/postgresql-96-released-1703/