Postgres Changelog - All Versions

This is a complete, one-page listing of changes across all Postgres versions. All versions 10 and older are EOL (end of life) and unsupported. This page was generated on September 14, 2023 by a script (version 1.33) by Greg Sabino Mullane, and contains information for 484 versions of Postgres.

Postgres 16
(end of life: Nov 9, 2028)

16.0 (2023-09-14)
Postgres 15
(end of life: Nov 11, 2027)

15.4 (2023-08-10)
15.3 (2023-05-11)
15.2 (2023-02-09)
15.1 (2022-11-10)
15.0 (2022-10-13)
Postgres 14
(end of life: Nov 12, 2026)

14.9 (2023-08-10)
14.8 (2023-05-11)
14.7 (2023-02-09)
14.6 (2022-11-10)
14.5 (2022-08-11)
14.4 (2022-06-16)
14.3 (2022-05-12)
14.2 (2022-02-10)
14.1 (2021-11-11)
14.0 (2021-09-30)
Postgres 13
(end of life: Nov 13, 2025)

13.12 (2023-08-10)
13.11 (2023-05-11)
13.10 (2023-02-09)
13.9 (2022-11-10)
13.8 (2022-08-11)
13.7 (2022-05-12)
13.6 (2022-02-10)
13.5 (2021-11-11)
13.4 (2021-08-12)
13.3 (2021-05-13)
13.2 (2021-02-11)
13.1 (2020-11-12)
13.0 (2020-09-24)
Postgres 12
(end of life: Nov 14, 2024)

12.16 (2023-08-10)
12.15 (2023-05-11)
12.14 (2023-02-09)
12.13 (2022-11-10)
12.12 (2022-08-11)
12.11 (2022-05-12)
12.10 (2022-02-10)
12.9 (2021-11-11)
12.8 (2021-08-12)
12.7 (2021-05-13)
12.6 (2021-02-11)
12.5 (2020-11-12)
12.4 (2020-08-13)
12.3 (2020-05-14)
12.2 (2020-02-13)
12.1 (2019-11-14)
12.0 (2019-10-03)
Postgres 11
(end of life: Nov 9, 2023)

11.21 (2023-08-10)
11.20 (2023-05-11)
11.19 (2023-02-09)
11.18 (2022-11-10)
11.17 (2022-08-11)
11.16 (2022-05-12)
11.15 (2022-02-10)
11.14 (2021-11-11)
11.13 (2021-08-12)
11.12 (2021-05-13)
11.11 (2021-02-11)
11.10 (2020-11-12)
11.9 (2020-08-13)
11.8 (2020-05-14)
11.7 (2020-02-13)
11.6 (2019-11-14)
11.5 (2019-08-08)
11.4 (2019-06-20)
11.3 (2019-05-09)
11.2 (2019-02-14)
11.1 (2018-11-08)
11.0 (2018-10-18)
Postgres 10
(end of life: Nov 10, 2022)

10.23 (2022-11-10)
10.22 (2022-08-11)
10.21 (2022-05-12)
10.20 (2022-02-10)
10.19 (2021-11-11)
10.18 (2021-08-12)
10.17 (2021-05-13)
10.16 (2021-02-11)
10.15 (2020-11-12)
10.14 (2020-08-13)
10.13 (2020-05-14)
10.12 (2020-02-13)
10.11 (2019-11-14)
10.10 (2019-08-08)
10.9 (2019-06-20)
10.8 (2019-05-09)
10.7 (2019-02-14)
10.6 (2018-11-08)
10.5 (2018-08-09)
10.4 (2018-05-10)
10.3 (2018-03-01)
10.2 (2018-02-08)
10.1 (2017-11-09)
10.0 (2017-10-05)
Postgres 9.6
(end of life: Nov 11, 2021)

9.6.24 (2021-11-11)
9.6.23 (2021-08-12)
9.6.22 (2021-05-13)
9.6.21 (2021-02-11)
9.6.20 (2020-11-12)
9.6.19 (2020-08-13)
9.6.18 (2020-05-14)
9.6.17 (2020-02-13)
9.6.16 (2019-11-14)
9.6.15 (2019-08-08)
9.6.14 (2019-06-20)
9.6.13 (2019-05-09)
9.6.12 (2019-02-14)
9.6.11 (2018-11-08)
9.6.10 (2018-08-09)
9.6.9 (2018-05-10)
9.6.8 (2018-03-01)
9.6.7 (2018-02-08)
9.6.6 (2017-11-09)
9.6.5 (2017-08-31)
9.6.4 (2017-08-10)
9.6.3 (2017-05-11)
9.6.2 (2017-02-09)
9.6.1 (2016-10-27)
9.6.0 (2016-09-29)
Postgres 9.5
(end of life: Feb 11, 2021)

9.5.25 (2021-02-11)
9.5.24 (2020-11-12)
9.5.23 (2020-08-13)
9.5.22 (2020-05-14)
9.5.21 (2020-02-13)
9.5.20 (2019-11-14)
9.5.19 (2019-08-08)
9.5.18 (2019-06-20)
9.5.17 (2019-05-09)
9.5.16 (2019-02-14)
9.5.15 (2018-11-08)
9.5.14 (2018-08-09)
9.5.13 (2018-05-10)
9.5.12 (2018-03-01)
9.5.11 (2018-02-08)
9.5.10 (2017-11-09)
9.5.9 (2017-08-31)
9.5.8 (2017-08-10)
9.5.7 (2017-05-11)
9.5.6 (2017-02-09)
9.5.5 (2016-10-27)
9.5.4 (2016-08-11)
9.5.3 (2016-05-12)
9.5.2 (2016-03-31)
9.5.1 (2016-02-11)
9.5.0 (2016-01-07)
Postgres 9.4
(end of life: Feb 13, 2020)

9.4.26 (2020-02-13)
9.4.25 (2019-11-14)
9.4.24 (2019-08-08)
9.4.23 (2019-06-20)
9.4.22 (2019-05-09)
9.4.21 (2019-02-14)
9.4.20 (2018-11-08)
9.4.19 (2018-08-09)
9.4.18 (2018-05-10)
9.4.17 (2018-03-01)
9.4.16 (2018-02-08)
9.4.15 (2017-11-09)
9.4.14 (2017-08-31)
9.4.13 (2017-08-10)
9.4.12 (2017-05-11)
9.4.11 (2017-02-09)
9.4.10 (2016-10-27)
9.4.9 (2016-08-11)
9.4.8 (2016-05-12)
9.4.7 (2016-03-31)
9.4.6 (2016-02-11)
9.4.5 (2015-10-08)
9.4.4 (2015-06-12)
9.4.3 (2015-06-04)
9.4.2 (2015-05-22)
9.4.1 (2015-02-05)
9.4.0 (2014-12-18)
Postgres 9.3
(end of life: Nov 8, 2018)

9.3.25 (2018-11-08)
9.3.24 (2018-08-09)
9.3.23 (2018-05-10)
9.3.22 (2018-03-01)
9.3.21 (2018-02-08)
9.3.20 (2017-11-09)
9.3.19 (2017-08-31)
9.3.18 (2017-08-10)
9.3.17 (2017-05-11)
9.3.16 (2017-02-09)
9.3.15 (2016-10-27)
9.3.14 (2016-08-11)
9.3.13 (2016-05-12)
9.3.12 (2016-03-31)
9.3.11 (2016-02-11)
9.3.10 (2015-10-08)
9.3.9 (2015-06-12)
9.3.8 (2015-06-04)
9.3.7 (2015-05-22)
9.3.6 (2015-02-05)
9.3.5 (2014-07-24)
9.3.4 (2014-03-20)
9.3.3 (2014-02-20)
9.3.2 (2013-12-05)
9.3.1 (2013-10-10)
9.3.0 (2013-09-09)
Postgres 9.2
(end of life: Nov 9, 2017)

9.2.24 (2017-11-09)
9.2.23 (2017-08-31)
9.2.22 (2017-08-10)
9.2.21 (2017-05-11)
9.2.20 (2017-02-09)
9.2.19 (2016-10-27)
9.2.18 (2016-08-11)
9.2.17 (2016-05-12)
9.2.16 (2016-03-31)
9.2.15 (2016-02-11)
9.2.14 (2015-10-08)
9.2.13 (2015-06-12)
9.2.12 (2015-06-04)
9.2.11 (2015-05-22)
9.2.10 (2015-02-05)
9.2.9 (2014-07-24)
9.2.8 (2014-03-20)
9.2.7 (2014-02-20)
9.2.6 (2013-12-05)
9.2.5 (2013-10-10)
9.2.4 (2013-04-04)
9.2.3 (2013-02-07)
9.2.2 (2012-12-06)
9.2.1 (2012-09-24)
9.2.0 (2012-09-10)
Postgres 9.1
(end of life: Oct 27, 2016)

9.1.24 (2016-10-27)
9.1.23 (2016-08-11)
9.1.22 (2016-05-12)
9.1.21 (2016-03-31)
9.1.20 (2016-02-11)
9.1.19 (2015-10-08)
9.1.18 (2015-06-12)
9.1.17 (2015-06-04)
9.1.16 (2015-05-22)
9.1.15 (2015-02-05)
9.1.14 (2014-07-24)
9.1.13 (2014-03-20)
9.1.12 (2014-02-20)
9.1.11 (2013-12-05)
9.1.10 (2013-10-10)
9.1.9 (2013-04-04)
9.1.8 (2013-02-07)
9.1.7 (2012-12-06)
9.1.6 (2012-09-24)
9.1.5 (2012-08-17)
9.1.4 (2012-06-04)
9.1.3 (2012-02-27)
9.1.2 (2011-12-05)
9.1.1 (2011-09-26)
9.1.0 (2011-09-12)
Postgres 9.0
(end of life: Oct 8, 2015)

9.0.23 (2015-10-08)
9.0.22 (2015-06-12)
9.0.21 (2015-06-04)
9.0.20 (2015-05-22)
9.0.19 (2015-02-05)
9.0.18 (2014-07-24)
9.0.17 (2014-03-20)
9.0.16 (2014-02-20)
9.0.15 (2013-12-05)
9.0.14 (2013-10-10)
9.0.13 (2013-04-04)
9.0.12 (2013-02-07)
9.0.11 (2012-12-06)
9.0.10 (2012-09-24)
9.0.9 (2012-08-17)
9.0.8 (2012-06-04)
9.0.7 (2012-02-27)
9.0.6 (2011-12-05)
9.0.5 (2011-09-26)
9.0.4 (2011-04-18)
9.0.3 (2011-01-31)
9.0.2 (2010-12-16)
9.0.1 (2010-10-04)
9.0.0 (2010-09-20)
Postgres 8.4
(end of life: Jul 24, 2014)

8.4.22 (2014-07-24)
8.4.21 (2014-03-20)
8.4.20 (2014-02-20)
8.4.19 (2013-12-05)
8.4.18 (2013-10-10)
8.4.17 (2013-04-04)
8.4.16 (2013-02-07)
8.4.15 (2012-12-06)
8.4.14 (2012-09-24)
8.4.13 (2012-08-17)
8.4.12 (2012-06-04)
8.4.11 (2012-02-27)
8.4.10 (2011-12-05)
8.4.9 (2011-09-26)
8.4.8 (2011-04-18)
8.4.7 (2011-01-31)
8.4.6 (2010-12-16)
8.4.5 (2010-10-04)
8.4.4 (2010-05-17)
8.4.3 (2010-03-15)
8.4.2 (2009-12-14)
8.4.1 (2009-09-09)
8.4.0 (2009-07-01)
Postgres 8.3
(end of life: Feb 7, 2013)

8.3.23 (2013-02-07)
8.3.22 (2012-12-06)
8.3.21 (2012-09-24)
8.3.20 (2012-08-17)
8.3.19 (2012-06-04)
8.3.18 (2012-02-27)
8.3.17 (2011-12-05)
8.3.16 (2011-09-26)
8.3.15 (2011-04-18)
8.3.14 (2011-01-31)
8.3.13 (2010-12-16)
8.3.12 (2010-10-04)
8.3.11 (2010-05-17)
8.3.10 (2010-03-15)
8.3.9 (2009-12-14)
8.3.8 (2009-09-09)
8.3.7 (2009-03-16)
8.3.6 (2009-02-02)
8.3.5 (2008-11-03)
8.3.4 (2008-09-22)
8.3.3 (2008-06-12)
8.3.2 (never released!)
8.3.1 (2008-03-17)
8.3.0 (2008-02-04)
Postgres 8.2
(end of life: Dec 5, 2011)

8.2.23 (2011-12-05)
8.2.22 (2011-09-26)
8.2.21 (2011-04-18)
8.2.20 (2011-01-31)
8.2.19 (2010-12-16)
8.2.18 (2010-10-04)
8.2.17 (2010-05-17)
8.2.16 (2010-03-15)
8.2.15 (2009-12-14)
8.2.14 (2009-09-09)
8.2.13 (2009-03-16)
8.2.12 (2009-02-02)
8.2.11 (2008-11-03)
8.2.10 (2008-09-22)
8.2.9 (2008-06-12)
8.2.8 (never released!)
8.2.7 (2008-03-17)
8.2.6 (2008-01-07)
8.2.5 (2007-09-17)
8.2.4 (2007-04-23)
8.2.3 (2007-02-07)
8.2.2 (2007-02-05)
8.2.1 (2007-01-08)
8.2.0 (2006-12-05)
Postgres 8.1
(end of life: Nov 8, 2010)

8.1.23 (2010-12-16)
8.1.22 (2010-10-04)
8.1.21 (2010-05-17)
8.1.20 (2010-03-15)
8.1.19 (2009-12-14)
8.1.18 (2009-09-09)
8.1.17 (2009-03-16)
8.1.16 (2009-02-02)
8.1.15 (2008-11-03)
8.1.14 (2008-09-22)
8.1.13 (2008-06-12)
8.1.12 (never released!)
8.1.11 (2008-01-07)
8.1.10 (2007-09-17)
8.1.9 (2007-04-23)
8.1.8 (2007-02-07)
8.1.7 (2007-02-05)
8.1.6 (2007-01-08)
8.1.5 (2006-10-16)
8.1.4 (2006-05-23)
8.1.3 (2006-02-14)
8.1.2 (2006-01-09)
8.1.1 (2005-12-12)
8.1.0 (2005-11-08)
Postgres 8.0
(end of life: Oct 1, 2010)

8.0.26 (2010-10-04)
8.0.25 (2010-05-17)
8.0.24 (2010-03-15)
8.0.23 (2009-12-14)
8.0.22 (2009-09-09)
8.0.21 (2009-03-16)
8.0.20 (2009-02-02)
8.0.19 (2008-11-03)
8.0.18 (2008-09-22)
8.0.17 (2008-06-12)
8.0.16 (never released!)
8.0.15 (2008-01-07)
8.0.14 (2007-09-17)
8.0.13 (2007-04-23)
8.0.12 (2007-02-07)
8.0.11 (2007-02-05)
8.0.10 (2007-01-08)
8.0.9 (2006-10-16)
8.0.8 (2006-05-23)
8.0.7 (2006-02-14)
8.0.6 (2006-01-09)
8.0.5 (2005-12-12)
8.0.4 (2005-10-04)
8.0.3 (2005-05-09)
8.0.2 (2005-04-07)
8.0.1 (2005-01-31)
8.0.0 (2005-01-19)
Postgres 7.4
(end of life: Oct 1, 2010)

7.4.30 (2010-10-04)
7.4.29 (2010-05-17)
7.4.28 (2010-03-15)
7.4.27 (2009-12-14)
7.4.26 (2009-09-09)
7.4.25 (2009-03-16)
7.4.24 (2009-02-02)
7.4.23 (2008-11-03)
7.4.22 (2008-09-22)
7.4.21 (2008-06-12)
7.4.20 (never released!)
7.4.19 (2008-01-07)
7.4.18 (2007-09-17)
7.4.17 (2007-04-23)
7.4.16 (2007-02-05)
7.4.15 (2007-01-08)
7.4.14 (2006-10-16)
7.4.13 (2006-05-23)
7.4.12 (2006-02-14)
7.4.11 (2006-01-09)
7.4.10 (2005-12-12)
7.4.9 (2005-10-04)
7.4.8 (2005-05-09)
7.4.7 (2005-01-31)
7.4.6 (2004-10-22)
7.4.5 (2004-08-18)
7.4.4 (2004-08-16)
7.4.3 (2004-06-14)
7.4.2 (2004-03-08)
7.4.1 (2003-12-22)
7.4.0 (2003-11-17)
Postgres 7.3
(end of life: Nov 27, 2007)

7.3.21 (2008-01-07)
7.3.20 (2007-09-17)
7.3.19 (2007-04-23)
7.3.18 (2007-02-05)
7.3.17 (2007-01-08)
7.3.16 (2006-10-16)
7.3.15 (2006-05-23)
7.3.14 (2006-02-14)
7.3.13 (2006-01-09)
7.3.12 (2005-12-12)
7.3.11 (2005-10-04)
7.3.10 (2005-05-09)
7.3.9 (2005-01-31)
7.3.8 (2004-10-22)
7.3.7 (2004-08-16)
7.3.6 (2004-03-02)
7.3.5 (2003-12-03)
7.3.4 (2003-07-24)
7.3.3 (2003-05-22)
7.3.2 (2003-02-04)
7.3.1 (2002-12-18)
7.3.0 (2002-11-27)
Postgres 7.2
(end of life: Feb 4, 2007)

7.2.8 (2005-05-09)
7.2.7 (2005-01-31)
7.2.6 (2004-10-22)
7.2.5 (2004-08-16)
7.2.4 (2003-01-30)
7.2.3 (2002-10-01)
7.2.2 (2002-08-23)
7.2.1 (2002-03-21)
7.2.0 (2002-02-04)
Postgres 7.1
(end of life: Apr 13, 2006)

7.1.3 (2001-08-15)
7.1.2 (2001-05-11)
7.1.1 (2001-05-05)
7.1.0 (2001-04-13)

Postgres 7.0
(end of life: May 8, 2005)

7.0.3 (2000-11-11)
7.0.2 (2000-06-05)
7.0.1 (2000-06-01)
7.0.0 (2000-05-08)
Postgres 6.5
(end of life: Jun 9, 2004)

6.5.3 (1999-10-13)
6.5.2 (1999-09-15)
6.5.1 (1999-07-15)
6.5.0 (1999-06-09)

Postgres 6.4
(end of life: Oct 30, 2003)

6.4.2 (1998-12-20)
6.4.1 (1998-12-18)
6.4.0 (1998-10-30)

Postgres 6.3
(end of life: Mar 1, 2003)

6.3.2 (1998-04-07)
6.3.1 (1998-03-23)
6.3.0 (1998-03-01)

Postgres 6.2
(end of life)

6.2.1 (1997-10-17)
6.2.0 (1997-10-02)

Postgres 6.1
(end of life)

6.1.1 (1997-07-22)
6.1.0 (1997-06-08)

Postgres 6.0 and earlier...
(end of life)

6.0.0 (1997-01-29)
1.09 (1996-11-04)
1.02 (1996-08-01)
1.01 (1996-02-23)
1.0 (1995-09-05)
0.03 (1995-07-21)
0.02 (1995-05-25)
0.01 (1995-05-01)

Postgres version 16.0

Release date: 2023-09-14

 Overview

PostgreSQL 16 contains many new features and enhancements, including:

The above items and other new features of PostgreSQL 16 are explained in more detail in the sections below.

 Migration to Version 16

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 19.6 for general information on migrating to new major releases.

Version 16 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:

 Changes

Below you will find a detailed account of the changes between PostgreSQL 16 and the previous major release.

 Server (PG 16.0)

 Optimizer (PG 16.0)

 General Performance (PG 16.0)

 Monitoring (PG 16.0)

 Privileges (PG 16.0)

 Server Configuration (PG 16.0)

 pg_hba.conf (PG 16.0)

 Localization (PG 16.0)

 Logical Replication (PG 16.0)

 Utility Commands (PG 16.0)

 Data Types (PG 16.0)

 General Queries (PG 16.0)

 Functions (PG 16.0)

 PL/pgSQL (PG 16.0)

 libpq (PG 16.0)

 Client Applications (PG 16.0)

 psql (PG 16.0)

 pg_dump (PG 16.0)

 Server Applications (PG 16.0)

 Source Code (PG 16.0)

 Additional Modules (PG 16.0)

 postgres_fdw (PG 16.0)

 Acknowledgments

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

Postgres version 15.4

Release date: 2023-08-10

This release contains a variety of fixes from 15.3. For information about new features in major release 15, see Version 15.0.

 Migration to Version 15.4

A dump/restore is not required for those running 15.X.

However, if you use BRIN indexes, it may be advisable to reindex them; see the third changelog entry below.

Also, if you are upgrading from a version earlier than 15.1, see Version 15.1.

 Changes

Postgres version 15.3

Release date: 2023-05-11

This release contains a variety of fixes from 15.2. For information about new features in major release 15, see Version 15.0.

 Migration to Version 15.3

A dump/restore is not required for those running 15.X.

However, if you are upgrading from a version earlier than 15.1, see Version 15.1.

 Changes

Postgres version 15.2

Release date: 2023-02-09

This release contains a variety of fixes from 15.1. For information about new features in major release 15, see Version 15.0.

 Migration to Version 15.2

A dump/restore is not required for those running 15.X.

However, if you are upgrading from a version earlier than 15.1, see Version 15.1.

 Changes

Postgres version 15.1

Release date: 2022-11-10

This release contains a variety of fixes from 15.0. For information about new features in major release 15, see Version 15.0.

 Migration to Version 15.1

A dump/restore is not required for those running 15.X.

However, if you regularly create and drop tables exceeding 1GB, see the first changelog entry below.

 Changes

Postgres version 15.0

Release date: 2022-10-13

 Overview

PostgreSQL 15 contains many new features and enhancements, including:

The above items and other new features of PostgreSQL 15 are explained in more detail in the sections below.

 Migration to Version 15

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 19.6 for general information on migrating to new major releases.

Version 15 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:

 Changes

Below you will find a detailed account of the changes between PostgreSQL 15 and the previous major release.

 Server (PG 15.0)

 Partitioning (PG 15.0)

 Indexes (PG 15.0)

 Optimizer (PG 15.0)

 General Performance (PG 15.0)

 Monitoring (PG 15.0)

 Privileges (PG 15.0)

 Server Configuration (PG 15.0)

 Streaming Replication and Recovery (PG 15.0)

 Logical Replication (PG 15.0)

 Utility Commands (PG 15.0)

 Data Types (PG 15.0)

 Functions (PG 15.0)

 PL/pgSQL (PG 15.0)

 libpq (PG 15.0)

 Client Applications (PG 15.0)

 psql (PG 15.0)

 pg_dump (PG 15.0)

 Server Applications (PG 15.0)

 pg_upgrade (PG 15.0)

 pg_waldump (PG 15.0)

 Documentation (PG 15.0)

 Source Code (PG 15.0)

 Additional Modules (PG 15.0)

 postgres_fdw (PG 15.0)

 Acknowledgments

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

Postgres version 14.9

Release date: 2023-08-10

This release contains a variety of fixes from 14.8. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.9

A dump/restore is not required for those running 14.X.

However, if you use BRIN indexes, it may be advisable to reindex them; see the second changelog entry below.

Also, if you are upgrading from a version earlier than 14.4, see Version 14.4.

 Changes

Postgres version 14.8

Release date: 2023-05-11

This release contains a variety of fixes from 14.7. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.8

A dump/restore is not required for those running 14.X.

However, if you are upgrading from a version earlier than 14.4, see Version 14.4.

 Changes

Postgres version 14.7

Release date: 2023-02-09

This release contains a variety of fixes from 14.6. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.7

A dump/restore is not required for those running 14.X.

However, if you are upgrading from a version earlier than 14.4, see Version 14.4.

 Changes

Postgres version 14.6

Release date: 2022-11-10

This release contains a variety of fixes from 14.5. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.6

A dump/restore is not required for those running 14.X.

However, if you are upgrading from a version earlier than 14.4, see Version 14.4.

 Changes

Postgres version 14.5

Release date: 2022-08-11

This release contains a variety of fixes from 14.4. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.5

A dump/restore is not required for those running 14.X.

However, if you are upgrading from a version earlier than 14.4, see Version 14.4.

 Changes

Postgres version 14.4

Release date: 2022-06-16

This release contains a variety of fixes from 14.3. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.4

A dump/restore is not required for those running 14.X.

However, if you have any indexes that were created using the CONCURRENTLY option under 14.X, you should re-index them after updating. See the first changelog entry below.

Also, if you are upgrading from a version earlier than 14.3, see Version 14.3.

 Changes

Postgres version 14.3

Release date: 2022-05-12

This release contains a variety of fixes from 14.2. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.3

A dump/restore is not required for those running 14.X.

However, if you have any GiST indexes on columns of type ltree (supplied by the contrib/ltree extension), you should re-index them after updating. See the second changelog entry below.

Also, if you are upgrading from a version earlier than 14.2, see Version 14.2.

 Changes

Postgres version 14.2

Release date: 2022-02-10

This release contains a variety of fixes from 14.1. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.2

A dump/restore is not required for those running 14.X.

However, some bugs have been found that may have resulted in corrupted indexes, as explained in the first two changelog entries. If any of those cases apply to you, it's recommended to reindex possibly-affected indexes after updating.

Also, if you are upgrading from a version earlier than 14.1, see Version 14.1.

 Changes

Postgres version 14.1

Release date: 2021-11-11

This release contains a variety of fixes from 14.0. For information about new features in major release 14, see Version 14.0.

 Migration to Version 14.1

A dump/restore is not required for those running 14.X.

However, note that installations using physical replication should update standby servers before the primary server, as explained in the third changelog entry below.

Also, several bugs have been found that may have resulted in corrupted indexes, as explained in the next several changelog entries. If any of those cases apply to you, it's recommended to reindex possibly-affected indexes after updating.

 Changes

Postgres version 14.0

Release date: 2021-09-30

 Overview

PostgreSQL 14 contains many new features and enhancements, including:

The above items and other new features of PostgreSQL 14 are explained in more detail in the sections below.

 Migration to Version 14

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 19.6 for general information on migrating to new major releases.

Version 14 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:

 Changes

Below you will find a detailed account of the changes between PostgreSQL 14 and the previous major release.

 Server (PG 14.0)

 Vacuuming (PG 14.0)

 Partitioning (PG 14.0)

 Indexes (PG 14.0)

 Optimizer (PG 14.0)

 General Performance (PG 14.0)

 Monitoring (PG 14.0)

 System Views (PG 14.0)

 Authentication (PG 14.0)

 Server Configuration (PG 14.0)

 Streaming Replication and Recovery (PG 14.0)

 Logical Replication (PG 14.0)

 SELECT, INSERT (PG 14.0)

 Utility Commands (PG 14.0)

 Data Types (PG 14.0)

 Functions (PG 14.0)

 PL/pgSQL (PG 14.0)

 Client Interfaces (PG 14.0)

 Client Applications (PG 14.0)

 psql (PG 14.0)

 Server Applications (PG 14.0)

 Documentation (PG 14.0)

 Source Code (PG 14.0)

 Additional Modules (PG 14.0)

 pg_stat_statements (PG 14.0)

 postgres_fdw (PG 14.0)

 Acknowledgments

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

Postgres version 13.12

Release date: 2023-08-10

This release contains a variety of fixes from 13.11. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.12

A dump/restore is not required for those running 13.X.

However, if you use BRIN indexes, it may be advisable to reindex them; see the second changelog entry below.

Also, if you are upgrading from a version earlier than 13.7, see Version 13.7.

 Changes

Postgres version 13.11

Release date: 2023-05-11

This release contains a variety of fixes from 13.10. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.11

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.7, see Version 13.7.

 Changes

Postgres version 13.10

Release date: 2023-02-09

This release contains a variety of fixes from 13.9. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.10

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.7, see Version 13.7.

 Changes

Postgres version 13.9

Release date: 2022-11-10

This release contains a variety of fixes from 13.8. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.9

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.7, see Version 13.7.

 Changes

Postgres version 13.8

Release date: 2022-08-11

This release contains a variety of fixes from 13.7. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.8

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.7, see Version 13.7.

 Changes

Postgres version 13.7

Release date: 2022-05-12

This release contains a variety of fixes from 13.6. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.7

A dump/restore is not required for those running 13.X.

However, if you have any GiST indexes on columns of type ltree (supplied by the contrib/ltree extension), you should re-index them after updating. See the second changelog entry below.

Also, if you are upgrading from a version earlier than 13.6, see Version 13.6.

 Changes

Postgres version 13.6

Release date: 2022-02-10

This release contains a variety of fixes from 13.5. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.6

A dump/restore is not required for those running 13.X.

However, if you have applied REINDEX CONCURRENTLY to a TOAST table's index, or observe failures to access TOAST datums, see the first changelog entry below.

Also, if you are upgrading from a version earlier than 13.5, see Version 13.5.

 Changes

Postgres version 13.5

Release date: 2021-11-11

This release contains a variety of fixes from 13.4. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.5

A dump/restore is not required for those running 13.X.

However, note that installations using physical replication should update standby servers before the primary server, as explained in the third changelog entry below.

Also, several bugs have been found that may have resulted in corrupted indexes, as explained in the next several changelog entries. If any of those cases apply to you, it's recommended to reindex possibly-affected indexes after updating.

Also, if you are upgrading from a version earlier than 13.2, see Version 13.2.

 Changes

Postgres version 13.4

Release date: 2021-08-12

This release contains a variety of fixes from 13.3. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.4

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.2, see Version 13.2.

 Changes

Postgres version 13.3

Release date: 2021-05-13

This release contains a variety of fixes from 13.2. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.3

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.2, see Version 13.2.

 Changes

Postgres version 13.2

Release date: 2021-02-11

This release contains a variety of fixes from 13.1. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.2

A dump/restore is not required for those running 13.X.

However, see the first changelog item below concerning a possible need to update stored views. Also see the third and fourth changelog items, which describe cases in which reindexing indexes after the upgrade may be advisable.

 Changes

Postgres version 13.1

Release date: 2020-11-12

This release contains a variety of fixes from 13.0. For information about new features in major release 13, see Version 13.0.

 Migration to Version 13.1

A dump/restore is not required for those running 13.X.

 Changes

Postgres version 13.0

Release date: 2020-09-24

 Overview

PostgreSQL 13 contains many new features and enhancements, including:

The above items and other new features of PostgreSQL 13 are explained in more detail in the sections below.

 Migration to Version 13

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 18.6 for general information on migrating to new major releases.

Version 13 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:

 Changes

Below you will find a detailed account of the changes between PostgreSQL 13 and the previous major release.

 Server (PG 13.0)

 Partitioning (PG 13.0)

 Indexes (PG 13.0)

 Optimizer (PG 13.0)

 General Performance (PG 13.0)

 Monitoring (PG 13.0)

 System Views (PG 13.0)

 Wait Events (PG 13.0)

 Authentication (PG 13.0)

 Server Configuration (PG 13.0)

 Streaming Replication and Recovery (PG 13.0)

 Utility Commands (PG 13.0)

 Data Types (PG 13.0)

 Functions (PG 13.0)

 PL/pgSQL (PG 13.0)

 Client Interfaces (PG 13.0)

 Client Applications (PG 13.0)

 psql (PG 13.0)

 pgbench (PG 13.0)

 Server Applications (PG 13.0)

 Documentation (PG 13.0)

 Source Code (PG 13.0)

 Additional Modules (PG 13.0)

 Acknowledgments

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

Postgres version 12.16

Release date: 2023-08-10

This release contains a variety of fixes from 12.15. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.16

A dump/restore is not required for those running 12.X.

However, if you use BRIN indexes, it may be advisable to reindex them; see the second changelog entry below.

Also, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.15

Release date: 2023-05-11

This release contains a variety of fixes from 12.14. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.15

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.14

Release date: 2023-02-09

This release contains a variety of fixes from 12.13. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.14

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.13

Release date: 2022-11-10

This release contains a variety of fixes from 12.12. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.13

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.12

Release date: 2022-08-11

This release contains a variety of fixes from 12.11. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.12

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.11

Release date: 2022-05-12

This release contains a variety of fixes from 12.10. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.11

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.10, see Version 12.10.

 Changes

Postgres version 12.10

Release date: 2022-02-10

This release contains a variety of fixes from 12.9. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.10

A dump/restore is not required for those running 12.X.

However, if you have applied REINDEX CONCURRENTLY to a TOAST table's index, or observe failures to access TOAST datums, see the first changelog entry below.

Also, if you are upgrading from a version earlier than 12.9, see Version 12.9.

 Changes

Postgres version 12.9

Release date: 2021-11-11

This release contains a variety of fixes from 12.8. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.9

A dump/restore is not required for those running 12.X.

However, note that installations using physical replication should update standby servers before the primary server, as explained in the third changelog entry below.

Also, several bugs have been found that may have resulted in corrupted indexes, as explained in the next several changelog entries. If any of those cases apply to you, it's recommended to reindex possibly-affected indexes after updating.

Also, if you are upgrading from a version earlier than 12.6, see Version 12.6.

 Changes

Postgres version 12.8

Release date: 2021-08-12

This release contains a variety of fixes from 12.7. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.8

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.6, see Version 12.6.

 Changes

Postgres version 12.7

Release date: 2021-05-13

This release contains a variety of fixes from 12.6. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.7

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.6, see Version 12.6.

 Changes

Postgres version 12.6

Release date: 2021-02-11

This release contains a variety of fixes from 12.5. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.6

A dump/restore is not required for those running 12.X.

However, see the second and third changelog items below, which describe cases in which reindexing indexes after the upgrade may be advisable.

Also, if you are upgrading from a version earlier than 12.2, see Version 12.2.

 Changes

Postgres version 12.5

Release date: 2020-11-12

This release contains a variety of fixes from 12.4. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.5

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.2, see Version 12.2.

 Changes

Postgres version 12.4

Release date: 2020-08-13

This release contains a variety of fixes from 12.3. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.4

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.2, see Version 12.2.

 Changes

Postgres version 12.3

Release date: 2020-05-14

This release contains a variety of fixes from 12.2. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.3

A dump/restore is not required for those running 12.X.

However, if you are upgrading from a version earlier than 12.2, see Version 12.2.

 Changes

Postgres version 12.2

Release date: 2020-02-13

This release contains a variety of fixes from 12.1. For information about new features in major release 12, see Version 12.0.

 Migration to Version 12.2

A dump/restore is not required for those running 12.X.

However, if you have any foreign key constraints referencing partitioned tables, see the two entries below about bugs in that feature.

 Changes