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 September 24, 2020 by a script (version 1.24) by Greg Sabino Mullane, and contains information for 416 versions of Postgres.

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

13.0 (2020-09-24)
Postgres 12
(end of life: Nov 14, 2024)

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


Prev  Up  Next
Appendix E. Release Notes  Home  E.2. Prior Releases

Return to the Release Notes Archive

Versions

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

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

Postgres version 9.6.4

Release 9.6.4

Release date: 2017-08-10

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

Migration to Version 9.6.4

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

However, if you use foreign data servers that make use of user passwords for authentication, see the first changelog entry below.

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

Changes

Postgres version 9.6.3

Release 9.6.3

Release date: 2017-05-11

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

Migration to Version 9.6.3

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

However, if you use foreign data servers that make use of user passwords for authentication, see the first changelog entry below.

Also, if you are using third-party replication tools that depend on "logical decoding", see the fourth changelog entry below.

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

Changes

Postgres version 9.6.2

Release 9.6.2

Release date: 2017-02-09

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

Migration to Version 9.6.2

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

However, if your installation has been affected by the bug described in the first changelog entry below, then after updating you may need to take action to repair corrupted indexes.

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

Changes

Postgres version 9.6.1

Release 9.6.1

Release date: 2016-10-27

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

Migration to Version 9.6.1

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

However, if your installation has been affected by the bugs described in the first two changelog entries below, then after updating you may need to take action to repair corrupted free space maps and/or visibility maps.

Changes

Postgres version 9.6.0

Release 9.6

Release date: 2016-09-29

Overview

Major enhancements in PostgreSQL 9.6 include:

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

Migration to Version 9.6

A dump/restore using pg_dumpall, or use of pg_upgrade, is required for those wishing to migrate data from any previous release.

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

Server

Parallel Queries

Indexes

Sorting

Locking

Optimizer Statistics

VACUUM

General Performance

Monitoring

Authentication

Server Configuration

Reliability

Replication and Recovery

Queries

Utility Commands

Permissions Management

Data Types

Functions

Server-Side Languages

Client Interfaces

Client Applications

psql

pgbench

Server Applications

Source Code

Additional Modules