Postgres Changelog - All Versions

This is a complete, one-page listing of changes across all Postgres versions. All versions 9.4 and older are EOL (end of life) and unsupported. This page was generated on February 11, 2021 by a script (version 1.26) by Greg Sabino Mullane, and contains information for 428 versions of Postgres.

Postgres 13
(end of life: Nov 13, 2025)

13.2 (2021-02-11)
13.1 (2020-11-12)
13.0 (2020-09-24)
Postgres 12
(end of life: Nov 14, 2024)

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.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.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.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 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

 Partitioning

 Indexes

 Optimizer

 General Performance

 Monitoring

 System Views

 Wait Events

 Authentication

 Server Configuration

 Streaming Replication and Recovery

 Utility Commands

 Data Types

 Functions

 PL/pgSQL

 Client Interfaces

 Client Applications

 psql

 pgbench

 Server Applications

 Documentation

 Source Code

 Additional Modules

 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.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

Postgres version 12.1

Release date: 2019-11-14

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

 Migration to Version 12.1

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

 Changes

Postgres version 12.0

Release date: 2019-10-03

 Overview

Major enhancements in PostgreSQL 12 include:

The above items are explained in more detail in the sections below.

 Migration to Version 12

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 12 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 12 and the previous major release.

 Server

 Partitioning

 Indexes

 Optimizer

 General Performance

 Monitoring

 Authentication

 Server Configuration

 Streaming Replication and Recovery

 Utility Commands

 Data Types

 Functions

 PL/pgSQL

 Client Interfaces

 Client Applications

 psql

 pgbench

 Server Applications

 pg_dump, pg_dumpall, pg_restore

 Source Code

 Additional Modules

 Acknowledgments

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

Postgres version 11.11

Release date: 2021-02-11

This release contains a variety of fixes from 11.10. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.11

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

However, see the second changelog item below, which describes cases in which reindexing indexes after the upgrade may be advisable.

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

 Changes

Postgres version 11.10

Release date: 2020-11-12

This release contains a variety of fixes from 11.9. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.10

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

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

 Changes

Postgres version 11.9

Release date: 2020-08-13

This release contains a variety of fixes from 11.8. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.9

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

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

 Changes

Postgres version 11.8

Release date: 2020-05-14

This release contains a variety of fixes from 11.7. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.8

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

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

 Changes

Postgres version 11.7

Release date: 2020-02-13

This release contains a variety of fixes from 11.6. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.7

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

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

 Changes

Postgres version 11.6

Release date: 2019-11-14

This release contains a variety of fixes from 11.5. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.6

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

However, if you use the contrib/intarray extension with a GiST index, and you rely on indexed searches for the <@ operator, see the entry below about that.

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

 Changes

Postgres version 11.5

Release date: 2019-08-08

This release contains a variety of fixes from 11.4. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.5

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

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

 Changes

Postgres version 11.4

Release date: 2019-06-20

This release contains a variety of fixes from 11.3. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.4

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

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

 Changes

Postgres version 11.3

Release date: 2019-05-09

This release contains a variety of fixes from 11.2. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.3

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

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

 Changes

Postgres version 11.2

Release date: 2019-02-14

This release contains a variety of fixes from 11.1. For information about new features in major release 11, see Version 11.0.

 Migration to Version 11.2

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

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

 Changes

Postgres version 11.1

Release date: 2018-11-08

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

 Migration to Version 11.1

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

However, if you use the pg_stat_statements extension, see the changelog entry below about that.

 Changes

Postgres version 11.0

Release date: 2018-10-18

 Overview

Major enhancements in PostgreSQL 11 include:

The above items are explained in more detail in the sections below.

 Migration to Version 11

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 11 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 11 and the previous major release.

 Server

 Partitioning

 Parallel Queries

 Indexes

 SP-Gist

 Optimizer

 General Performance

 Monitoring

 Information Schema

 Authentication

 Permissions

 Server Configuration

 Write-Ahead Log (WAL)

 Base Backup and Streaming Replication

 Utility Commands

 Data Types

 Functions

 Server-Side Languages

 Client Interfaces

 Client Applications

 psql

 pgbench

 Server Applications

 pg_dump, pg_dumpall, pg_restore

 Source Code

 Additional Modules

 Acknowledgments

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

Postgres version 10.16

Release date: 2021-02-11

This release contains a variety of fixes from 10.15. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.16

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

However, see the first changelog item below, which describes cases in which reindexing indexes after the upgrade may be advisable.

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

 Changes

Postgres version 10.15

Release date: 2020-11-12

This release contains a variety of fixes from 10.14. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.15

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

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

 Changes

Postgres version 10.14

Release date: 2020-08-13

This release contains a variety of fixes from 10.13. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.14

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

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

 Changes

Postgres version 10.13

Release date: 2020-05-14

This release contains a variety of fixes from 10.12. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.13

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

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

 Changes

Postgres version 10.12

Release date: 2020-02-13

This release contains a variety of fixes from 10.11. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.12

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

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

 Changes

Postgres version 10.11

Release date: 2019-11-14

This release contains a variety of fixes from 10.10. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.11

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

However, if you use the contrib/intarray extension with a GiST index, and you rely on indexed searches for the <@ operator, see the entry below about that.

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

 Changes

Postgres version 10.10

Release date: 2019-08-08

This release contains a variety of fixes from 10.9. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.10

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

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

 Changes

Postgres version 10.9

Release date: 2019-06-20

This release contains a variety of fixes from 10.8. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.9

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

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

 Changes

Postgres version 10.8

Release date: 2019-05-09

This release contains a variety of fixes from 10.7. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.8

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

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

 Changes

Postgres version 10.7

Release date: 2019-02-14

This release contains a variety of fixes from 10.6. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.7

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

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

 Changes

Postgres version 10.6

Release date: 2018-11-08

This release contains a variety of fixes from 10.5. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.6

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

However, if you use the pg_stat_statements extension, see the changelog entry below about that.

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

 Changes

Postgres version 10.5

Release date: 2018-08-09

This release contains a variety of fixes from 10.4. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.5

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

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

 Changes

Postgres version 10.4

Release date: 2018-05-10

This release contains a variety of fixes from 10.3. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.4

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

However, if you use the adminpack extension, you should update it as per the first changelog entry below.

Also, if the function marking mistakes mentioned in the second and third changelog entries below affect you, you will want to take steps to correct your database catalogs.

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

 Changes

Postgres version 10.3

Release date: 2018-03-01

This release contains a variety of fixes from 10.2. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.3

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

However, if you run an installation in which not all users are mutually trusting, or if you maintain an application or extension that is intended for use in arbitrary situations, it is strongly recommended that you read the documentation changes described in the first changelog entry below, and take suitable steps to ensure that your installation or code is secure.

Also, the changes described in the second changelog entry below may cause functions used in index expressions or materialized views to fail during auto-analyze, or when reloading from a dump. After upgrading, monitor the server logs for such problems, and fix affected functions.

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

 Changes

Postgres version 10.2

Release date: 2018-02-08

This release contains a variety of fixes from 10.1. For information about new features in major release 10, see Version 10.0.

 Migration to Version 10.2

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

However, if you use contrib/cube's ~> operator, see the entry below about that.

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

 Changes

Postgres version 10.1

Release date: 2017-11-09

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

 Migration to Version 10.1

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

However, if you use BRIN indexes, see the fourth changelog entry below.

 Changes

Postgres version 10.0

Release date: 2017-10-05

 Overview

Major enhancements in PostgreSQL 10 include:

The above items are explained in more detail in the sections below.

 Migration to Version 10

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 10 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 10 and the previous major release.

 Server

 Parallel Queries

 Indexes

 Locking

 Optimizer

 General Performance

 Monitoring

 Logging

 pg_stat_activity

 Authentication

 Server Configuration

 Reliability

 Write-Ahead Log (WAL)

 Replication and Recovery

 Queries

 Utility Commands

 Data Types

 Functions

 Server-Side Languages

 PL/Tcl

 Client Interfaces

 Client Applications

 psql

 pgbench

 Server Applications

 pg_dump, pg_dumpall, pg_restore

 pg_basebackup

 pg_ctl

 Source Code

 Additional Modules

 Acknowledgments

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

Postgres version 9.6.21

Release date: 2021-02-11

This release contains a variety of fixes from 9.6.20. For information about new features in the 9.6 major release, see Version 9.6.0.

The PostgreSQL community will stop releasing updates for the 9.6.X release series in November 2021. Users are encouraged to update to a newer release branch soon.

Migration to Version 9.6.21

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

However, see the first changelog item below, which describes cases in which reindexing indexes after the upgrade may be advisable.

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

Changes

Postgres version 9.6.20

Release date: 2020-11-12

This release contains a variety of fixes from 9.6.19. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.20

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

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

Changes

Postgres version 9.6.19

Release date: 2020-08-13

This release contains a variety of fixes from 9.6.18. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.19

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

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

Changes

Postgres version 9.6.18

Release date: 2020-05-14

This release contains a variety of fixes from 9.6.17. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.18

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

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

Changes

Postgres version 9.6.17

Release date: 2020-02-13

This release contains a variety of fixes from 9.6.16. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.17

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

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

Changes

Postgres version 9.6.16

Release date: 2019-11-14

This release contains a variety of fixes from 9.6.15. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.16

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

However, if you use the contrib/intarray extension with a GiST index, and you rely on indexed searches for the <@ operator, see the entry below about that.

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

Changes

Postgres version 9.6.15

Release date: 2019-08-08

This release contains a variety of fixes from 9.6.14. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.15

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

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

Changes

Postgres version 9.6.14

Release date: 2019-06-20

This release contains a variety of fixes from 9.6.13. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.14

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

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

Changes

Postgres version 9.6.13

Release date: 2019-05-09

This release contains a variety of fixes from 9.6.12. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.13

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

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

Changes

Postgres version 9.6.12

Release date: 2019-02-14

This release contains a variety of fixes from 9.6.11. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.12

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

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

Changes

Postgres version 9.6.11

Release date: 2018-11-08

This release contains a variety of fixes from 9.6.10. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.11

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

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

Changes

Postgres version 9.6.10

Release date: 2018-08-09

This release contains a variety of fixes from 9.6.9. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.10

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

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

Changes

Postgres version 9.6.9

Release date: 2018-05-10

This release contains a variety of fixes from 9.6.8. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.9

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

However, if you use the adminpack extension, you should update it as per the first changelog entry below.

Also, if the function marking mistakes mentioned in the second and third changelog entries below affect you, you will want to take steps to correct your database catalogs.

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

Changes

Postgres version 9.6.8

Release date: 2018-03-01

This release contains a variety of fixes from 9.6.7. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.8

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

However, if you run an installation in which not all users are mutually trusting, or if you maintain an application or extension that is intended for use in arbitrary situations, it is strongly recommended that you read the documentation changes described in the first changelog entry below, and take suitable steps to ensure that your installation or code is secure.

Also, the changes described in the second changelog entry below may cause functions used in index expressions or materialized views to fail during auto-analyze, or when reloading from a dump. After upgrading, monitor the server logs for such problems, and fix affected functions.

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

Changes

Postgres version 9.6.7

Release date: 2018-02-08

This release contains a variety of fixes from 9.6.6. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.7

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

However, if you use contrib/cube's ~> operator, see the entry below about that.

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

Changes

Postgres version 9.6.6

Release date: 2017-11-09

This release contains a variety of fixes from 9.6.5. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.6

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

However, if you use BRIN indexes, see the fourth changelog entry below.

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

Changes

Postgres version 9.6.5

Release date: 2017-08-31

This release contains a small number of fixes from 9.6.4. For information about new features in the 9.6 major release, see Version 9.6.0.

Migration to Version 9.6.5

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

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

Changes